Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id 68CCE2E0038
	for <pgsql-sql-postgresql.org@developer.postgresql.org>;
	Wed, 16 Apr 2008 04:15:10 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 85278-05
	for <pgsql-sql-postgresql.org@developer.postgresql.org>;
	Wed, 16 Apr 2008 04:15:02 -0300 (ADT)
X-Greylist: delayed 00:15:02.903852 by SQLgrey-1.7.5
Received: from omr3.networksolutionsemail.com (omr3.networksolutionsemail.com
	[205.178.146.53])
	by developer.postgresql.org (Postfix) with ESMTP id 877612E0037
	for <pgsql-sql@postgresql.org>; Wed, 16 Apr 2008 04:15:02 -0300 (ADT)
Received: from mail.networksolutionsemail.com (ns-omr3.mgt.netsolmail.com
	[10.49.6.66])
	by omr3.networksolutionsemail.com (8.13.6/8.13.6) with SMTP id
	m3G6xwuX005910
	for <pgsql-sql@postgresql.org>; Wed, 16 Apr 2008 02:59:58 -0400
Received: (qmail 31234 invoked by uid 78); 16 Apr 2008 06:59:57 -0000
Received: from unknown (HELO sumayavm) (41.208.253.42)
	by ns-omr3.lb.hosting.dc2.netsol.com with SMTP;
	16 Apr 2008 06:59:57 -0000
Message-ID: <000601c89f8f$7741f490$0f02000a@sumayavm>
From: "Sumaya" <sumaya@silvermoongroup.com>
To: <pgsql-sql@postgresql.org>
Subject: Multiple databases
Date: Wed, 16 Apr 2008 08:59:46 +0200
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0003_01C89FA0.37E298C0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200804/91
X-Sequence-Number: 30630

This is a multi-part message in MIME format.

------=_NextPart_000_0003_01C89FA0.37E298C0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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
------=_NextPart_000_0003_01C89FA0.37E298C0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2180" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I am converting sql code from sql =
server to=20
postgresql.&nbsp; Data is currently being retrieved from multiple =
databases, how=20
do I do this using postgresql.&nbsp; I have tried using eg. select * =
from=20
datbasename.tablename but this does not work.&nbsp; Any =
ideas?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Sumaya</FONT></DIV></BODY></HTML>

------=_NextPart_000_0003_01C89FA0.37E298C0--