Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5305365043C for ; Tue, 19 Aug 2008 19:54:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 45362-01-2 for ; Tue, 19 Aug 2008 19:53:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from dmzms99802.na.baesystems.com (dmzms99802.na.baesystems.com [149.32.232.66]) by postgresql.org (Postfix) with ESMTP id 928CA64FD16 for ; Tue, 19 Aug 2008 19:53:14 -0300 (ADT) Message-Id: <738m08$3l61o@dmzms99802.na.baesystems.com> X-SENDER-IP: 10.37.193.66 X-SENDER-REPUTATION: None X-IronPort-AV: E=Sophos;i="4.32,237,1217808000"; d="scan'208";a="3840056" Received: from rfc1918.na.baesystems.com (HELO vahnms99902.na.baesystems.com) ([10.37.193.66]) by dmzms99802.na.baesystems.com with ESMTP/TLS/RC4-SHA; 19 Aug 2008 22:43:31 +0000 X-SENDER-IP: 166.18.8.16 X-SENDER-REPUTATION: None X-IronPort-AV: E=Sophos;i="4.32,237,1217808000"; d="scan'208";a="1032358" X-MimeOLE: Produced By Microsoft Exchange V6.0.6619.12 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: schema name in the SQL statement. Date: Tue, 19 Aug 2008 18:43:27 -0400 X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: schema name in the SQL statement. Thread-Index: AckCTPrr0KNmCvS/T8KsHHM79uPSDQ== From: "Masis, Alexander \(US SSA\)" To: X-OriginalArrivalTime: 19 Aug 2008 22:43:27.0789 (UTC) FILETIME=[FF20F5D0:01C9024C] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.495 tagged_above=0 required=5 tests=MSGID_FROM_MTA_HEADER=1.495 X-Spam-Level: * X-Archive-Number: 200808/14 X-Sequence-Number: 6789 My db has one schema. In fact I deleted the default "public" and created my own: "schema_1". In my SQL query I have to explicitly specify schema name: "select my_colomn from schema_1.table_name;" Can't schema be specified as default value during connection, or can I set the schema before I send the query?