Thread: Schema
Somebody knows how to get a sql "schema" of a Postgresql database?? Thanks!! Gerardo Tagliani Linux Registred User #139437 ----------------------------------------------- FREE! The World's Best Email Address @email.com Reserve your name now at http://www.email.com
On Tue, Dec 19, 2000 at 12:51:26PM -0500, gerardo tagliani wrote: > Somebody knows how to get a sql "schema" of a Postgresql database?? pg_dump -s -d <dbname> -- Adam Haberlach |A cat spends her life conflicted between a adam@newsnipple.com |deep, passionate, and profound desire for http://www.newsnipple.com |fish and an equally deep, passionate, and '88 EX500 |profound desire to avoid getting wet.
At 12:51 19/12/00 -0500, gerardo tagliani wrote: >Somebody knows how to get a sql "schema" of a Postgresql database?? > >Thanks!! pg_dump -s databasename -- thorNET - Internet Consultancy, Services & Training Phone: 01454 854413 Fax: 01454 854412 http://www.thornet.co.uk
At 10:04 19/12/00 -0800, Adam Haberlach wrote: >On Tue, Dec 19, 2000 at 12:51:26PM -0500, gerardo tagliani wrote: >> Somebody knows how to get a sql "schema" of a Postgresql database?? > >pg_dump -s -d <dbname> > No. -d does something to the INSERT strings -- thorNET - Internet Consultancy, Services & Training Phone: 01454 854413 Fax: 01454 854412 http://www.thornet.co.uk