Re: how can I create the DML for an existing database - within an application - Mailing list pgsql-general

From Dave Page
Subject Re: how can I create the DML for an existing database - within an application
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E4011C9C74@ratbert.vale-housing.co.uk
Whole thread Raw
In response to how can I create the DML for an existing database - within an application  ("Harald Armin Massa" <haraldarminmassa@gmail.com>)
List pgsql-general

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of
> Magnus Hagander
> Sent: 13 April 2006 08:40
> To: Harald Armin Massa; pgsql-general
> Subject: Re: [GENERAL] how can I create the DML for an
> existing database - within an application
>
> > I want to get the output from
> >
> > pg_dump --struct-only --table=whatever
> >
> > inside a programm. Of course I could call pg_dump in a seperate
> > process and capture the output and all; but ...
> >
> > as PGAdmin is doing it someway, I strongly suspect there is
> a kind of
> > call to recreate the DML language from a table in the
> database. Please
> > give me a hint!
>
> AFAIK, pgadmin opens a pipe to pg_dump.

Yes, when creating an actual backup. To display the definition on the
main window it goes to great pains to reverse engineer the SQL from the
catalogues.

Regards, Dave

pgsql-general by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: how can I create the DML for an existing database - within an application
Next
From: Paolo Sala
Date:
Subject: unattened dump