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