Re: PG Admin on the command line = pg_dump

From: Dave Page <dpage(at)postgresql(dot)org>
To: Laurent ROCHE <laurent_roche(at)yahoo(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: PG Admin on the command line = pg_dump
Date: 2006-12-27 09:07:18
Message-ID: 459237C6.6040707@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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.

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Clodoaldo 2006-12-27 09:34:47 Re: 1.6.1 and 1.7.0 rendering bug
Previous Message Dave Page 2006-12-27 08:57:29 Re: 1.6.1 and 1.7.0 rendering bug