On Mon, May 19, 2008 at 4:06 AM, Ramasubramanian G
<[EMAIL PROTECTED]> wrote:
> 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
atype.)
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 thi
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: [SQ
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
On Sat, May 17, 2008 at 6:58 PM, <[EMAIL PROTECTED]> 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
EnterpriseD
Hi,
I am accessing data across different databases using dblinks but the dates are
getting messed up:
table: mytable
columns: my_id int
my_date date
values: 1
2008-04-09
When retrieving data from the table in the relevant database the date is
returned correctly: 2008-04-09
but when retrieving a
