Postgres Pro
Downloads
Home   >   mailing lists

pg_dump does not dump index, constraints, sequences - Mailing list pgsql-admin

From Adi Alurkar
Subject pg_dump does not dump index, constraints, sequences
Date
Msg-id 1061330727.19768.8.camel@agni
Whole thread Raw
Responses Re: pg_dump does not dump index, constraints, sequences  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
Greetings

i am trying to export the schema for a database, in PG 7.2 running
pg_dump -s would extract the schema, but in Pg 7.3.4 pg_dump -s
extracts only the table definitions and does not extract the index,
sequence, constraint info, how do i extract all of this information from
the DB.

Appreciate all the help. thank you
--
Adi Alurkar (DBA sf.NET) <adi@vasoftware.com>
1024D/79730470 A491 5724 74DE 956D 06CB  D844 6DF1 B972 7973 0470
Attachment

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Help with pg_restore
Next
From: Chris Miles
Date:
Subject: This table won't use INDEX until I DUMP/RESTORE it ?