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

On 03/07/2007 13:47, Stefan Zweig wrote:

> 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

You can specify the username on the command line, but not the password:
the --password option only ensures the psql will prompt for the password.

The usual thing, as I understand it, is to use a .pgpass file: have a
look at the docs, here:

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

> very large *.sql files to import) and more convenient to do the
> import directly via psql instead of using jdbc/odbc.

Also, if the files you're importing were created by pg_dump, they'll
contain various "backslash" commands that are psql-specific, so you
*have* to re-import them via psql.

HTH,

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
---------------------------------------------------------------