> What version are you running? IIRC it should remember the password
> between databases.
8.4.0 on Linux/x86_64. It does not, and man page clearly says:
"pg_dumpall needs to connect several times to the
PostgreSQL server (once per database). If you use password
authentication it will
Hi,
is it possible to force pg_dumpall to ask for
password only once (connecting as superuser 'postgres') ?
Entering it for every database is a bit annoying.
Thanks,
Krzysztof
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http:/
> Just to make things clear, is this the same question and situation that
> Jerzy Bialas brought up in another post?
>
> http://archives.postgresql.org/pgsql-general/2009-09/msg00922.php
Yes, I didn't know he posted it earlier.
Sorry for the confusion and thanks for response.
Regards,
Krzysztof
Hi Tom,
> If that's not what you are talking about, you need to be more
> specific about what you are talking about.
you are right, I was not specific enough.
I meant a situation where returned rowset
may have different set of column names depending
on data in the database, not on explicit user
Hi,
I have a question - is it possible to rename
columns in rowset returned from plpgsql function
delared as 'returns table(...)' ?
It seems it's not possible, even using
'as "column_name"' in internal query and
column names are always the same as in
'table(...)' definition.
If not, could it be
