how to refer to tables in another database( or schema as oracle refers to)

From: Jiaqing <jjw72(at)swbell(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: how to refer to tables in another database( or schema as oracle refers to)
Date: 2002-08-19 21:52:39
Message-ID: 5.1.0.14.0.20020819164709.00a68270@postoffice.swbell.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,
I'm still new here and new to PostgreSQL, I'd like to know that after I
have created two databases on my site, such as one is called backend, and
another one is called admin, how do I refer(query) the table from backend
while I'm connected to admin database, or is it possible to do that in
PostgreSQL? any answer is appreciated.

JJW.
8/19/2002

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-08-20 01:35:51 Re: how to refer to tables in another database( or schema as oracle refers to)
Previous Message Darrin Domoney 2002-08-19 19:29:03 Re: [ADMIN] [SQL] Urgent - SQL Unique constraint error (long)