Re: pg_restore ignores PGDATABASE

On Sun, February 19, 2012 06:27, Robert Haas wrote:
> On Sat, Feb 18, 2012 at 11:58 AM, Erik Rijkers <er(at)xs4all(dot)nl> wrote:
>> pg_restore ignores environment variable PGDATABASE.
>
> What exactly do you mean by "ignores"? pg_restore prints results to
> standard output unless a database name is specified. AFAIK, there's
> no syntax to say "I want a direct-to-database restore to whatever you
> think the default database is".

That's right, and that seems contradictory with:

"This utility [pg_restore], like most other PostgreSQL utilities, also uses the environment
variables supported by libpq (see Section 31.13)."

as pg_restore does 'ignore' (for want of a better word) PGDATABASE.

But I think I can conclude from your reply that that behaviour is indeed intentional.

thanks,

Erik Rijkers