From: | "Ramasubramanian G" <ramasubramanian(dot)g(at)renaissance-it(dot)com> |
---|---|
To: | <sumaya(at)silvermoongroup(dot)com> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: dblinks |
Date: | 2008-05-19 03:06:47 |
Message-ID: | 84D57263D486374587DA0820E60A2CC601D95FB8@srit_mail.renaissance-it.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2008-05-19 08:22:16 | Re: dblinks |
Previous Message | Jonah H. Harris | 2008-05-18 12:02:18 | Re: dblinks |