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 used 8.1 and 8.2 with 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-support] PG Admin on the command line = pg_dump
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 SEQUENCES (I
> have scripts parsing the generated SQL file and looking for SERIAL columns).
>
> I was wondering if it is possible to use command line switches to make the
> fantastic PG Admin III generate a script (without any user interaction).
> I could not see any thing in the doc about that, so I am asking you guys and
> gals.
pgAdmin just uses pg_dump to generate it's backup scripts, so we don't
have any command line options to this as we'd just say 'use pg_dump'.
Regards, Dave.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
___________________________________________________________________________
Yahoo! Mail réinvente le mail ! Découvrez le nouveau Yahoo! Mail et son
interface révolutionnaire.
http://fr.mail.yahoo.com
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
