Postgres Pro
Downloads
Home   >   mailing lists

Re: Change Request: \pset pager off in pg_dumpall - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Change Request: \pset pager off in pg_dumpall
Date
Msg-id 200308112223.h7BMNla06915@candle.pha.pa.us
Whole thread Raw
In response to Change Request: \pset pager off in pg_dumpall  (Larry Rosenman <ler@lerctr.org>)
Responses Re: Change Request: \pset pager off in pg_dumpall
List pgsql-hackers
Tree view 
Larry Rosenman wrote:
> Can we modify pg_dumpall (or pg_dump?) to include a \pset pager off
> to prevent the setval() calls from halting an interactive \i of the dump 
> file?

Your pg_dump's actually invoke the pager?  Are you manually starting
psql, then doing \i dumpfile?  Why would you do that rather than psql
template1 <dumpfile?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Farewell
Next
From: Bruce Momjian
Date:
Subject: Re: [BUGS] ALTER TABLE table RENAME COLUMN x TO y