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:[EMAIL PROTECTED] Sent: Saturday, May 17, 2008 07:31 PM To: [EMAIL PROTECTED] Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] dblinksre On Sat, May 17, 2008 at 6:58 PM, wrote: > statement looks like > select * from [EMAIL PROTECTED]; 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 | [EMAIL PROTECTED] Edison, NJ 08837 | http://www.enterprisedb.com/
Re: [SQL] dblinks
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 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:[EMAIL PROTECTED] Sent: Saturday, May 17, 2008 07:31 PM To: [EMAIL PROTECTED] Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] dblinksre On Sat, May 17, 2008 at 6:58 PM, wrote: > statement looks like > select * from [EMAIL PROTECTED]; 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 | [EMAIL PROTECTED] Edison, NJ 08837 | http://www.enterprisedb.com/
Re: [SQL] dblinks
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. Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 499 Thornall Street, 2nd Floor | [EMAIL PROTECTED] Edison, NJ 08837 | http://www.enterprisedb.com/ -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] 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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Sunday, May 18, 2008 2:18 PM
To: Jonah H. Harris; [EMAIL PROTECTED]
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:[EMAIL PROTECTED]
Sent: Saturday, May 17, 2008 07:31 PM
To: [EMAIL PROTECTED]
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] dblinksre
On Sat, May 17, 2008 at 6:58 PM, wrote: > statement looks like >
select * from [EMAIL PROTECTED]; 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 |
[EMAIL PROTECTED] Edison, NJ 08837 |
http://www.enterprisedb.com/
