Re: pg_dump "all tables" in 7.3.X
От | Paul Ramsey |
---|---|
Тема | Re: pg_dump "all tables" in 7.3.X |
Дата | |
Msg-id | 3EFB3357.4080009@refractions.net обсуждение исходный текст |
Ответ на | Re: pg_dump "all tables" in 7.3.X (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: pg_dump "all tables" in 7.3.X
|
Список | pgsql-general |
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@refractions.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@refractions.net | Phone: (250) 885-0632 \_
В списке pgsql-general по дате отправления: