Re: [SQL] dblinks

2008-05-18 Thread sumaya
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

Re: [SQL] dblinks

2008-05-18 Thread sumaya
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

[SQL] dblinks

2008-05-17 Thread sumaya
across dblinks using statement below, I get the following error: statement looks like select * from [EMAIL PROTECTED]; the error refers to the datestyle setting and shows the date as '2008-09-04' Please advise if there is a way around this. Thanks, Sumaya

[SQL] Multiple databases

2008-04-16 Thread Sumaya
Hi, I am converting sql code from sql server to postgresql. Data is currently being retrieved from multiple databases, how do I do this using postgresql. I have tried using eg. select * from datbasename.tablename but this does not work. Any ideas? Thanks, Sumaya