Re: dblinks

HI Sumaya,

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(at)postgresql(dot)org
[mailto:pgsql-sql-owner(at)postgresql(dot)org] On Behalf Of
sumaya(at)silvermoongroup(dot)com
Sent: Sunday, May 18, 2008 2:18 PM
To: Jonah H. Harris; sumaya(at)silvermoongroup(dot)com
Cc: pgsql-sql(at)postgresql(dot)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(dot)harris(at)gmail(dot)com]
Sent: Saturday, May 17, 2008 07:31 PM
To: sumaya(at)silvermoongroup(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] dblinksre

On Sat, May 17, 2008 at 6:58 PM, wrote: > statement looks like >
select * from mytable(at)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(dot)harris(at)enterprisedb(dot)com Edison, NJ 08837 |
http://www.enterprisedb.com/