Hi Jiaqing, Basically - you can't. There is a program in the contrib/dblink directory that can help you though.
Regards, Chris > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Jiaqing > Sent: Tuesday, 20 August 2002 5:53 AM > To: [EMAIL PROTECTED] > Subject: [SQL] how to refer to tables in another database( or schema as > oracle refers to) > > > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
