Postgres中需要a1 a2序列

• create table test ( a text );

CREATE TABLE

• insert into test(a) select 'A'||generate_series(1,4)::text;

INSERT 0 4

• select * from test;

 a  
----
 A1
 A2
 A3
 A4
(4 rows)