Hi List;

I've setup an ODBC connection from my Linux/Postgres laptop to a Lunux/postgres server. I can connect via isql to the remote database.

How can I select data from the remote database from within an sql statement in psql on my local machine?

For example I'd like to be able to specify the server@database.table to connect on the fly from straight SQL.

Is this possible?





---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq