On Sun, February 19, 2012 06:27, Robert Haas wrote:
> On Sat, Feb 18, 2012 at 11:58 AM, Erik Rijkers <er@xs4all.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