Re: PG Admin on the command line = pg_dump - Mailing list pgadmin-support

From Raymond O'Donnell
Subject Re: PG Admin on the command line = pg_dump
Date
Msg-id 45924EB6.17491.2D1801@rod.iol.ie
Whole thread Raw
In response to PG Admin on the command line = pg_dump  (Laurent ROCHE <laurent_roche@yahoo.com>)
List pgadmin-support
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
----------------------------------------------------------------------




pgadmin-support by date:

Previous
From: Clodoaldo
Date:
Subject: Re: 1.6.1 and 1.7.0 rendering bug
Next
From: Laurent ROCHE
Date:
Subject: Re : PG Admin on the command line = pg_dump