Skip site navigation (1) Skip section navigation (2)

Re: pg_dump "all tables" in 7.3.X

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Paul Ramsey <pramsey(at)refractions(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump "all tables" in 7.3.X
Date: 2003-06-26 17:46:28
Message-ID: 1202.1056649588@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
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

In response to

Responses

pgsql-hackers by date

Next:From: Paul RamseyDate: 2003-06-26 17:54:31
Subject: Re: pg_dump "all tables" in 7.3.X
Previous:From: Andrew GouldDate: 2003-06-26 17:43:44
Subject: Re: pg_dump "all tables" in 7.3.X

pgsql-general by date

Next:From: Paul RamseyDate: 2003-06-26 17:54:31
Subject: Re: pg_dump "all tables" in 7.3.X
Previous:From: Andrew GouldDate: 2003-06-26 17:43:44
Subject: Re: pg_dump "all tables" in 7.3.X

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group