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