Postgres Pro
Downloads
Home   >   mailing lists

schema name in the SQL statement. - Mailing list pgsql-interfaces

From Masis, Alexander \(US SSA\)
Subject schema name in the SQL statement.
Date
Msg-id 738m08$3l61o@dmzms99802.na.baesystems.com
Whole thread Raw
Responses Re: schema name in the SQL statement.  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: schema name in the SQL statement.  (Bosco Rama <postgres@boscorama.com>)
List pgsql-interfaces
Tree view 
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?

pgsql-interfaces by date:

Previous
From: "Masis, Alexander \(US SSA\)"
Date:
Subject: Where can I get the LIBPQ++
Next
From: Alvaro Herrera
Date:
Subject: Re: schema name in the SQL statement.