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
[EMAIL PROTECTED]
---------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
