Laurent ROCHE wrote:
I will be interested to get the command you use as I can not get the same
result with pg_dump as with PG Admin (re SERIAL) ! ? !
There is no 'command', just a whole bunch of different SQL queries tied
together with a few thousand lines of C++ code.
Regards, Dave.
-
Laurent ROCHE wrote:
Hi,
I am puzzled why when I use pg_dump I get a script with INTEGER and SEQUENCE
and when you (i.e. PG Admin) use pg_dump you get a script with SERIAL ?
Do you pass extra undocumented options to pg_dump ?
What version of pg_dump do you use in PG Admin III 1.6.1 ?
(I have u
the same results)
Have fun,
[EMAIL PROTECTED]
The Computing Froggy
- Message d'origine
De : Dave Page <[EMAIL PROTECTED]>
À : Laurent ROCHE <[EMAIL PROTECTED]>
Cc : pgadmin-support@postgresql.org
Envoyé le : Mercredi, 27 Décembre 2006, 10h07mn 18s
Objet : Re: [pgadmin-
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 wit
Laurent ROCHE wrote:
Hi,
I would like to automate the generation of a backup script of a schema (which I
used to perform with PG Admin backup command).
I looked into 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 SE
