Participants
Josef Springer
Josef Springer
Oisin Glynn
Oisin Glynn
Tom Lane
Tom Lane
Scott Marlowe
Scott Marlowe
Attachments
Show all attachments
Thread Outline
#1Josef SpringerJosef Springer
Jul 19, 2005
#2...#4
Oisin GlynnScott Marlowe
↳▸to Josef Springer (#1)
Jul 19, 2005
#2Oisin Glynn↳Oisin Glynnto Josef Springer (#1)
Jul 19, 2005
#4Scott Marlowe↳Scott Marloweto Oisin Glynn (#2)
Jul 19, 2005
#3Tom Lane↳Tom Laneto Josef Springer (#1)
Jul 19, 2005

How to pass the password for login in psql

Started by Josef Springerover 20 years ago4 messagesgeneral
Jump to latest
#1Josef Springer
Josef Springer
Josef.Springer@JOOPS.COM

Hi,

i want to use psql using the --username option. But i do not find an
option to pass the password. I want to use psql in a batch, so i want to
automate it.

Best Regards,
Josef Springer

Import Notes
Reference msg id not found: 200507130721.j6D7LloQ030756@hosting.commandprompt.com
#2Oisin Glynn
Oisin Glynn
me@oisinglynn.com
In reply to: Josef Springer (#1)
Re: How to pass the password for login in psql

BAT FILE SHOULD CONTAIN

set PGPASSWORD=postgres
"psql.exe" MYDATABASE -U postgres -f mysqlfile.sql

Oisin
----- Original Message -----
From: "Josef Springer" <Josef.Springer@JOOPS.COM>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, July 19, 2005 1:26 PM
Subject: [GENERAL] How to pass the password for login in psql

Show quoted text

Hi,

i want to use psql using the --username option. But i do not find an
option to pass the password. I want to use psql in a batch, so i want to
automate it.

Best Regards,
Josef Springer

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Import Notes
Reference msg id not found: 200507130721.j6D7LloQ030756@hosting.commandprompt.com
#3Tom Lane
Tom Lane
tgl@sss.pgh.pa.us
In reply to: Josef Springer (#1)
Re: How to pass the password for login in psql

Josef Springer <Josef.Springer@JOOPS.COM> writes:

i want to use psql using the --username option. But i do not find an
option to pass the password.

There are very good reasons for that.

I want to use psql in a batch, so i want to automate it.

Consider using a ~/.pgpass file.

regards, tom lane

#4Scott Marlowe
Scott Marlowe
smarlowe@g2switchworks.com
In reply to: Oisin Glynn (#2)
Re: How to pass the password for login in psql

FYI, this is deprecated in favor of a .pgpass file.

See:

http://www.postgresql.org/docs/8.0/static/libpq-pgpass.html

Show quoted text

On Tue, 2005-07-19 at 13:01, Oisin Glynn wrote:

BAT FILE SHOULD CONTAIN

set PGPASSWORD=postgres
"psql.exe" MYDATABASE -U postgres -f mysqlfile.sql

Oisin
----- Original Message -----
From: "Josef Springer" <Josef.Springer@JOOPS.COM>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, July 19, 2005 1:26 PM
Subject: [GENERAL] How to pass the password for login in psql

Hi,

i want to use psql using the --username option. But i do not find an
option to pass the password. I want to use psql in a batch, so i want to
automate it.

Best Regards,
Josef Springer

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

← Back to Topics