Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Sql > Multiple databa...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 3410 of 3559
Post > Topic >>

Multiple databases

by sumaya@[EMAIL PROTECTED] ("Sumaya") Apr 16, 2008 at 08:59 AM

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--
 




 3 Posts in Topic:
Multiple databases
sumaya@[EMAIL PROTECTED]   2008-04-16 08:59:46 
Re: Multiple databases
andreas.kretschmer@[EMAIL  2008-04-16 09:24:08 
Re: Multiple databases
gherzig@[EMAIL PROTECTED]  2008-04-16 09:01:02 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 6 19:45:56 CDT 2008.