Skip site navigation (1) Skip section navigation (2)

schema name in the SQL statement.

From: "Masis, Alexander \(US SSA\)" <alexander(dot)masis(at)baesystems(dot)com>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: schema name in the SQL statement.
Date: 2008-08-19 22:43:27
Message-ID: 738m08$3l61o@dmzms99802.na.baesystems.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
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?




Responses

pgsql-interfaces by date

Next:From: Masis, Alexander (US SSA)Date: 2008-08-19 22:47:56
Subject: Where can I get the LIBPQ++
Previous:From: Michael MeskesDate: 2008-08-19 10:31:18
Subject: Re: ecpg 'set' failure using host vars

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group