From: | Christoph Dalitz <christoph(dot)dalitz(at)hs-niederrhein(dot)de> |
---|---|
To: | medi(dot)montaseri(at)intransa(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org, stan(at)morgan(dot)harvard(dot)edu |
Subject: | Re: supplying password to psql on command line? |
Date: | 2002-10-29 07:52:12 |
Message-ID: | 20021029085212.7d6c7579.christoph.dalitz@hs-niederrhein.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> Date: Mon, 28 Oct 2002 10:56:32 -0800
> From: Medi Montaseri <medi(dot)montaseri(at)intransa(dot)com>
>
> I think Font ends are moving away from this approach as others can see
> your supplied
> passwd by a simple ps(1) command.
>
There used to be a program "hide.c" available from the oracle website,
which made this impossible. Unfortunately I can no longer find it.
A simpler approach however is to supply the password from stdin.
With Oracle's sqlplus this works as follows:
#!/bin/sh
sqlplus <<EOF
userid/password(at)tnasalias
/* SQL commands */
EOF
Unfortunately this does *not* work with psql because for some strange reason
psql does not read the password from stdin.
Christoph Dalitz
From | Date | Subject | |
---|---|---|---|
Next Message | Karel Zak | 2002-10-29 08:03:28 | Re: cast numeric to char |
Previous Message | Mario Weilguni | 2002-10-29 07:03:39 | Re: QUERY ABOUT EXPLAIN ANALYZE |