Re: pg_dump "all tables" in 7.3.X

From: Andrew Gould <andrewgould(at)yahoo(dot)com>
To: Andrew Gould <andrewgould(at)yahoo(dot)com>, Paul Ramsey <pramsey(at)refractions(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump "all tables" in 7.3.X
Date: 2003-06-26 18:14:05
Message-ID: 20030626181405.31850.qmail@web13406.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

oops that would be all databases

sorry

--- Andrew Gould <andrewgould(at)yahoo(dot)com> wrote:
> --- Paul Ramsey <pramsey(at)refractions(dot)net> wrote:
> > We are trying to do an "all tables" dump using the
> > 7.3.3 pg_dump, but
> > are getting no love. The pg_dump command which
> > worked before, in 7.2,
> > no longer returns any tables:
> >
> > pg_dump -t "*" dbname
> >
> > Is this by design, or by accident?
> >
> > Paul
> >
>
> try 'pg_dumpall dbname'
>
> Best of luck,
>
> Andrew
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose
> an index scan if your
> joining column's datatypes do not match

In response to

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-06-26 18:14:17 Re: python script for crosstab queries in PostgreSQL
Previous Message Andrew Gould 2003-06-26 18:12:32 python script for crosstab queries in PostgreSQL

Browse pgsql-hackers by date

  From Date Subject
Next Message Paul Ramsey 2003-06-26 18:17:47 Re: [GENERAL] pg_dump "all tables" in 7.3.X
Previous Message Tom Lane 2003-06-26 18:12:18 Re: pg_dump "all tables" in 7.3.X