Could you teach me, How can we specify password when using psql....

On Fri, Aug 06, 2010 at 01:35:58PM +0900, 노현석 wrote:

hi..

when using oracle sqlplus.. we can specify password.
$ sqlplus system/manager

Could you teach me, How can we specify password when using psql....
$ psql -p 5432 -h rac2 -d mydb -U hsnoh
Password for user hsnoh:

Thanks..

Overall, it's better to use a .pgpass (pgpass.conf on Windows)

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

It's also possible, but not recommended, to set an environment
variable.

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

David Fetter <david@fetter.org> writes:

On Fri, Aug 06, 2010 at 01:35:58PM +0900, 노현석 wrote:

when using oracle sqlplus.. we can specify password.
$ sqlplus system/manager

Could you teach me, How can we specify password when using psql....
$ psql -p 5432 -h rac2 -d mydb -U hsnoh
Password for user hsnoh:

Overall, it's better to use a .pgpass (pgpass.conf on Windows)

The reason why psql doesn't have that is that putting a password
directly on the command line is a security hole: any other process
on the machine can see psql's command line, on most platforms.

It's a security hole for Oracle, too --- you shouldn't be doing
things that way.

regards, tom lane