how to: psql -U user --password password ?

Hi list,

i have a problem with connecting to postgresql on a remote server.
basically i want to import some sets of data into the database, using the
psql command from within a shell script.
i have a local machine where postgres is installed and a remote one where
postgres is installed as well.
because of security issues the configuration of postgres on the remote
server is set in a way that i am not not allowed to connect to the
database from my local machine. and the security thing gets even stricter:
i am not even allowed to run a shell script on my remote server.

i know already that there is a way to connect to a remote postgres using
psql with the options --host 123.123.123.1 --port
5432 --username --password

unfortunately this only prompts the password screen and i have to input
the password for postgres for every single psql command again.. this not
very convenient in terms of automating imports using shell. i am planning
to do some hundreds of imports (with psql) on a batch and i want to avoid
typing the password some hundreds times.

i know that in mysql there is way to pass through the password e.g. to
mysqldump with mysqldump --user=user --password=password
actually i would need similar functionality in postgres. is there a good
way to solve my problem?

i know that a i could do the import as well using jdbc or odbc connections
to postgres (where it is possible to connect as a user with password), but
actually i think it is faster (as i have some very large *.sql files to
import) and more convenient to do the import directly via psql instead of
using jdbc/odbc.

i appreciate any help.

thanks in advance, stefan
_______________________________________________________________________
Jetzt neu! Schuetzen Sie Ihren PC mit McAfee und WEB.DE. 3 Monate
kostenlos testen. http://www.pc-sicherheit.web.de/startseite/?mc=022220

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Hi list,

i have a problem with connecting to postgresql on a remote server. basically i want to import some sets of data into the database, using the psql command from within a shell script.
i have a local machine where postgres is installed and a remote one where postgres is installed as well.
because of security issues the configuration of postgres on the remote server is set in a way that i am not not allowed to connect to the database from my local machine. and the security thing gets even stricter: i am not even allowed to run a shell script on my remote server.

i know already that there is a way to connect to a remote postgres using psql with the options --host 123.123.123.1 --port 5432 --username --password

unfortunately this only prompts the password screen and i have to input the password for postgres for every single psql command again.. this not very convenient in terms of automating imports using shell. i am planning to do some hundreds of imports (with psql) on a batch and i want to avoid typing the password some hundreds times.

i know that in mysql there is way to pass through the password e.g. to mysqldump with mysqldump --user=user --password=password
actually i would need similar functionality in postgres. is there a good way to solve my problem?

i know that a i could do the import as well using jdbc or odbc connections to postgres (where it is possible to connect as a user with password), but actually i think it is faster (as i have some very large *.sql files to import) and more convenient to do the import directly via psql instead of using jdbc/odbc.

i appreciate any help.

thanks in advance, stefan
_______________________________________________________________________
Jetzt neu! Schuetzen Sie Ihren PC mit McAfee und WEB.DE. 3 Monate
kostenlos testen. http://www.pc-sicherheit.web.de/startseite/?mc=022220

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster