On Mon, May 19, 2008 at 4:06 AM, Ramasubramanian G
<ramasubramanian.g@renaissance-it.com> 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_NAME','select * from mytable')as
> tmp(column1 datatype,column2 datatype.....)
The OP was using EnterpriseDB's Postgres Plus Advanced Server, which
has Oracle-style dblinks built in. They are not used in the same way
as the PostgreSQL dblink module.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
