Re: pg_dump "all tables" in 7.3.X

From: Paul Ramsey <pramsey(at)refractions(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org, "'gleeming(at)refractions(dot)net'" <gleeming(at)refractions(dot)net>
Subject: Re: pg_dump "all tables" in 7.3.X
Date: 2003-06-26 17:54:31
Message-ID: 3EFB3357.4080009@refractions.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

What the old 7.2 behavior gave us was the ability to dump all tables and
views, but not dump all the functions and triggers. Is there an
equivalent to that behavior still around?

Tom Lane wrote:
> Paul Ramsey <pramsey(at)refractions(dot)net> writes:
>
>>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?
>
>
> By design. Just omit the -t switch if you want all tables.
>
> ("*" is a legal table name, if perhaps not a very bright choice, so the
> old behavior was really not consistent.)
>
> regards, tom lane

--
__
/
| Paul Ramsey
| Refractions Research
| Email: pramsey(at)refractions(dot)net
| Phone: (250) 885-0632
\_

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Gould 2003-06-26 17:55:12 python script for crosstab queries in PostgreSQL
Previous Message Tom Lane 2003-06-26 17:46:28 Re: pg_dump "all tables" in 7.3.X

Browse pgsql-hackers by date

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