This is the way you have to use dblink. And one more think. To excute this query you nedd to have dblink functions installed in your database schema.
select * from dblink('YOUR_DB_LINK_NAME','select * from mytable')as tmp(column1 datatype,column2 datatype.....)
Regards,
Ram
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of sumaya@silvermoongroup.com Sent: Sunday, May 18, 2008 2:18 PM To: Jonah H. Harris; sumaya@silvermoongroup.com Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] dblinks
Hi,
I'm using enterpisedb.
The thing is it does return data, it's just that if there is a date column on the table, it gives me the error. Is there no way around this? Unfortunately the architecture will be able to be changed.
Thanks,
Sumaya
-----Original Message----- From: Jonah H. Harris [mailto:jonah.harris@gmail.com] Sent: Saturday, May 17, 2008 07:31 PM To: sumaya@silvermoongroup.com Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] dblinksre
On Sat, May 17, 2008 at 6:58 PM, wrote: > statement looks like > select * from mytable@mydblink; Postgres does not support this style of database link syntax. Are you using Oracle or EnterpriseDB? -- Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 499 Thornall Street, 2nd Floor | jonah.harris@enterprisedb.com Edison, NJ 08837 | http://www.enterprisedb.com/
