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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)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