pg_dump does not dump index, constraints, sequences

From: Adi Alurkar <adi(at)vasoftware(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_dump does not dump index, constraints, sequences
Date: 2003-08-19 22:05:28
Message-ID: 1061330727.19768.8.camel@agni
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)vasoftware(dot)com>
1024D/79730470 A491 5724 74DE 956D 06CB D844 6DF1 B972 7973 0470

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message theguardian 2003-08-20 00:19:19 Incremental Backup
Previous Message Stephan Szabo 2003-08-19 19:33:00 Re: changing field length