Thread: pg_dump does not dump index, constraints, sequences

pg_dump does not dump index, constraints, sequences

From
Adi Alurkar
Date:
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

Re: pg_dump does not dump index, constraints, sequences

From
Tom Lane
Date:
Adi Alurkar <adi@vasoftware.com> writes:
> 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,

Sure it does.  You'd better give a more detailed explanation of your
problem.

            regards, tom lane

Re: pg_dump does not dump index, constraints, sequences

From
Adi Alurkar
Date:
I have this problem only on ONE DB and not the others so it seems more
like an issue only with the pg_dump on that machine, sorry about this.

I also noticed that pg_dump -n is no longer supported is there any way
to dump data without quotes in PG 7.3.4?

On Thu, 2003-08-21 at 07:28, Tom Lane wrote:
> Adi Alurkar <adi@vasoftware.com> writes:
> > 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,
>
> Sure it does.  You'd better give a more detailed explanation of your
> problem.
>
>             regards, tom lane
--
Adi Alurkar (DBA sf.NET) <adi@vasoftware.com>
1024D/79730470 A491 5724 74DE 956D 06CB  D844 6DF1 B972 7973 0470

Attachment