Lists: | pgsql-generalpgsql-hackers |
---|
From: | Paul Ramsey <pramsey(at)refractions(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_dump "all tables" in 7.3.X |
Date: | 2003-06-26 17:36:09 |
Message-ID: | 3EFB2F09.4050903@refractions.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general pgsql-hackers |
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
--
__
/
| Paul Ramsey
| Refractions Research
| Email: pramsey(at)refractions(dot)net
| Phone: (250) 885-0632
\_
From: | Andrew Gould <andrewgould(at)yahoo(dot)com> |
---|---|
To: | 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 17:43:44 |
Message-ID: | 20030626174344.29782.qmail@web13407.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general pgsql-hackers |
--- 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
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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general pgsql-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
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 |
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
\_
From: | Paul Ramsey <pramsey(at)refractions(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [GENERAL] pg_dump "all tables" in 7.3.X |
Date: | 2003-06-26 17:55:28 |
Message-ID: | 3EFB3390.8050809@refractions.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general pgsql-hackers |
Oh, if it's by design then the "pg_dump --help" text should be updated
correspondingly. The online doco is already correct.
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
\_
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Paul Ramsey <pramsey(at)refractions(dot)net> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [GENERAL] pg_dump "all tables" in 7.3.X |
Date: | 2003-06-26 18:08:21 |
Message-ID: | 1393.1056650901@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general pgsql-hackers |
Paul Ramsey <pramsey(at)refractions(dot)net> writes:
> Oh, if it's by design then the "pg_dump --help" text should be updated
> correspondingly. The online doco is already correct.
Hm. Wait a minute --- I was thinking of 7.4 not 7.3. The "*" hack does
appear to still be there in the 7.3 source code. Are you sure you're
typing the command just like that?
> pg_dump -t "*" dbname
regards, tom lane
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, "'gleeming(at)refractions(dot)net'" <gleeming(at)refractions(dot)net> |
Subject: | Re: pg_dump "all tables" in 7.3.X |
Date: | 2003-06-26 18:12:18 |
Message-ID: | 1434.1056651138@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general pgsql-hackers |
Paul Ramsey <pramsey(at)refractions(dot)net> writes:
> 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?
Not at the moment. It would be a fine project to add more selectivity
options to pg_dump.
I wouldn't even object to reintroducing * into -t, if it were done
properly (ie, a real wild-card-match implementation, and not just a
two-line kluge that handles the one case) ...
regards, tom lane
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 |
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
From: | Paul Ramsey <pramsey(at)refractions(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [GENERAL] pg_dump "all tables" in 7.3.X |
Date: | 2003-06-26 18:17:47 |
Message-ID: | 3EFB38CB.7000405@refractions.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general pgsql-hackers |
Entirely sure:
[pramsey(at)hydra pg_dump]$ which pg_dump
/opt/pgsql73/bin/pg_dump
[pramsey(at)hydra pg_dump]$ pg_dump -t "*" pramsey
--
-- PostgreSQL database dump
--
[pramsey(at)hydra pg_dump]$
Tom Lane wrote:
> Paul Ramsey <pramsey(at)refractions(dot)net> writes:
>
>>Oh, if it's by design then the "pg_dump --help" text should be updated
>>correspondingly. The online doco is already correct.
>
>
> Hm. Wait a minute --- I was thinking of 7.4 not 7.3. The "*" hack does
> appear to still be there in the 7.3 source code. Are you sure you're
> typing the command just like that?
>
>> pg_dump -t "*" dbname
>
>
> regards, tom lane
--
__
/
| Paul Ramsey
| Refractions Research
| Email: pramsey(at)refractions(dot)net
| Phone: (250) 885-0632
\_
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Paul Ramsey <pramsey(at)refractions(dot)net> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [GENERAL] pg_dump "all tables" in 7.3.X |
Date: | 2003-06-26 18:18:20 |
Message-ID: | 1537.1056651500@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general pgsql-hackers |
Paul Ramsey <pramsey(at)refractions(dot)net> writes:
> Entirely sure:
Hmph. There must be some bug in the 7.3 code for it then. Since we've
already ripped out that code for 7.4, I'm not too excited about finding
the problem...
regards, tom lane