On 26 Dec 2006 at 17:42, Laurent ROCHE wrote:

> pg_dump command: it does the job BUT not correctly for me as it does
> not create SERIAL column but INTEGER and then it creates SEQUENCES (I

This is correct - SERIAL isn't a "real" data type, but rather a 
shortcut that creates an integer column with a default which executes 
nextval() on a sequence which it also creates.

http://www.postgresql.org/docs/8.2/static/datatype-
numeric.html#DATATYPE-SERIAL

--Ray.


----------------------------------------------------------------------

Raymond O'Donnell
Director of Music, Galway Cathedral, Galway, Ireland
[EMAIL PROTECTED]
----------------------------------------------------------------------



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to