Re: how can I create the DML for an existing database - within an application

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)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