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
rod@iol.ie
----------------------------------------------------------------------