Selecting data from a table created in another database...

From: "Ligia Pimentel" <lmpimentel(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Selecting data from a table created in another database...
Date: 2002-07-02 20:13:59
Message-ID: aft59r$24k1$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I don't know if this can be done...

In MSSQL Server I can access a table created in another database (on the
same server, of course) by using the following syntaxis...

select * from databasename..tablename where condition;

Can I do this in postgres?

I'm using version 7.2 on a redhat server...

Thank you for your help...

Ligia

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jie Liang 2002-07-02 23:08:37 Re: pg_restore cannot restore function
Previous Message Ricardo Javier Aranibar León 2002-07-02 20:07:37 constraint