Postgres Pro
Downloads
Home   >   mailing lists

Re: Database conversion type serial question - Mailing list pgsql-admin

From Tom Lane
Subject Re: Database conversion type serial question
Date
Msg-id 17944.1205507851@sss.pgh.pa.us
Whole thread Raw
In response to Database conversion type serial question  (Carol Walter <walterc@indiana.edu>)
List pgsql-admin
Tree view 
Carol Walter <walterc@indiana.edu> writes:
> Can I designate a column not
> previously defined as serial to serial.

"serial" is not really a type.  It's just a convenience macro for
creating a sequence and setting the column's default expression.
So what you do is perform those steps manually.  See
http://www.postgresql.org/docs/8.2/static/datatype-numeric.html#DATATYPE-SERIAL

            regards, tom lane

pgsql-admin by date:

Previous
From: Carol Walter
Date:
Subject: Database conversion type serial question
Next
From: "Marc Fromm"
Date:
Subject: howto restore from pg_dumpall