You can always use the environment variable PGPASSWORD to do that.
Though - it is not recommended to use for security reason. :(
Please follow the link for the details.
http://www.postgresql.org/docs/8.3/static/libpq-envars.html
--
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA - The Enterprise Postgres Company
"Make everything as simple as possible, but not simpler..." -- Albert Einstein
"We are what our thoughts have made us; so take care about what you think." -- Swami Vivekananda
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA - The Enterprise Postgres Company
"Make everything as simple as possible, but not simpler..." -- Albert Einstein
"We are what our thoughts have made us; so take care about what you think." -- Swami Vivekananda
On Tue, Nov 17, 2009 at 4:42 AM, Raymond O'Donnell <rod@xxxxxx> wrote:
On 16/11/2009 23:05, Raymond O'Donnell wrote:>> --username foo --password fee
> On 16/11/2009 22:51, Gauthier, Dave wrote:
[snip]
Actually, to correct myself, there *are* these options - but the
> There are no options such as these....what you do instead is use a
--password option just forces a password prompt - it doesn't actually
allow you to specify the password.
Have a look at psql --help for all the options.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@xxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general