Hi All,
I have a table which has 'SERIAL' datatype. When I use 'create table X
as select * from my-table' , it creates the table but without serial
datatype. I mean without implicit sequence.
test=> \d qptuser
Table "public.qptuser"
Column | Type | Modifiers
-----------+-----------------------+----------------------------------------------------------
srl | integer | not null default
nextval('public.qptuser_srl_seq'::text)
login_nme | character varying(35) | not null
password | character varying(30) | not null
Indexes:
"pk_qptuser" primary key, btree (srl)
"i1_qptuser_login_nme" unique, btree (login_nme)
test=> create table x as select * from qptuser;
test=> \d x
Table "public.a"
Column | Type | Modifiers
-----------+-----------------------+-----------
srl | integer |
login_nme | character varying(35) |
password | character varying(30) |
Can you help me on this?
Thanks,
- Arash
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
