SEO

#1 (**permalink**) 04-16-2008, 02:00 AM

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

#2 (**permalink**) 04-16-2008, 02:00 AM

> 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?

Is it ODBC related? I think psql isn't our focus.
BTW psql have to be connected to some backend (PgSQL server). So
I'm not sure if I understand you well.

> 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?

You could look at contrib/dblink. It could be what are you looking for.

Regards,

Luf

---------------------------(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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Connect to remote database via psql?