Schema

Started by gerardo taglianiover 25 years ago4 messagesgeneral
Jump to latest
#1gerardo tagliani
gdtpostgres@email.com

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

#2Steve Heaven
steve@thornet.co.uk
In reply to: gerardo tagliani (#1)
Re: Schema

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

#3Adam Haberlach
adam@newsnipple.com
In reply to: gerardo tagliani (#1)
Re: Schema

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.

#4Steve Heaven
steve@thornet.co.uk
In reply to: Adam Haberlach (#3)
Re: Schema

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