--- Alvaro Herrera <[EMAIL PROTECTED]> escribió: > On Tue, Oct 19, 2004 at 02:25:35PM -0400, Tom Lane > wrote: > > Jaime Casanova <[EMAIL PROTECTED]> writes: > > > but when i do a: pg_dump -C uescc > uescc.sql > > > it add the create statement for the database but > not > > > add appropiates alter database for the > parameters i > > > set search_path in this case. > > > > > But, pg_dumpall does. > > > > > a bug in pg_dump? > > > > No. That functionality is assigned to pg_dumpall.
Why in pg_dumpall and not in pg_dump -C? > > There doesn't seem to be a way of extracting only > database creation from > pg_dumpall. Or the schema of a single database, for > example. There > _is_ a functionality gap here. > > > ISTM pg_dump -C (which dumps CREATE DATABASE) should > dump ALTER DATABASE > commands too. It seems to be the logical behavior, IMHO. best regards, Jaime Casanova _________________________________________________________ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
