> -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx > [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] 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
