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,
R
On Sun, May 18, 2008 at 4:47 AM, <[EMAIL PROTECTED]> wrote:
> I'm using enterpisedb.
OK. As the Postgres community only supports PostgreSQL, please submit
this and all future EnterpriseDB questions directly to
[EMAIL PROTECTED] or http://forums.enterprisedb.com.
Thanks.
--
Jonah H. Harris, Sr
Hi,
I meant to say, the architecture will NOT be able to be changed.
Regards,
Sumaya
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Sunday, May 18, 2008 04:47 AM
To: 'Jonah H. Harris', [EMAIL PROTECTED]
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] dblinks
H
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 [ma
