Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 3243D2E0038 for ; Wed, 16 Apr 2008 04:24:16 -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 91427-08 for ; Wed, 16 Apr 2008 04:24:13 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.188]) by developer.postgresql.org (Postfix) with ESMTP id 6BDA82E0037 for ; Wed, 16 Apr 2008 04:24:13 -0300 (ADT) Received: from webserv.wug.de ([194.25.154.138]) by mrelayeu.kundenserver.de (node=mrelayeu7) with ESMTP (Nemesis) id 0ML2xA-1Jm20101na-0003cC; Wed, 16 Apr 2008 09:24:12 +0200 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1Jm200-0001aK-00 for pgsql-sql@postgresql.org; Wed, 16 Apr 2008 09:24:08 +0200 Date: Wed, 16 Apr 2008 09:24:08 +0200 From: "A. Kretschmer" To: pgsql-sql@postgresql.org Subject: Re: Multiple databases Message-ID: <20080416072408.GD1928@a-kretschmer.de> References: <000601c89f8f$7741f490$0f02000a@sumayavm> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <000601c89f8f$7741f490$0f02000a@sumayavm> X-OS: Debian/GNU Linux - weil ich es mir Wert bin! User-Agent: Mutt/1.5.9i X-Provags-ID: V01U2FsdGVkX18Yete6xxyFEyewwg5c8INTXumAIklpF+rza1C Q5PKo2nE/HYe2ynfuB2UIwxYNrR64Zlk1U2bAiviG9krSKmOkh DLSnQsFEBaGkvn63KXg0QVrCSEw8Fzv X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/92 X-Sequence-Number: 30631 am Wed, dem 16.04.2008, um 8:59:46 +0200 mailte Sumaya folgendes: > 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? You can use multiple databases, but you can't work across multiple databases. PostgreSQL offers schemas, you can use them. http://www.postgresql.org/docs/current/static/ddl-schemas.html Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net