Postgres Pro
Downloads
Home   >   mailing lists

schema name in SQL statement. - Mailing list pgsql-general

From Masis, Alexander \(US SSA\)
Subject schema name in SQL statement.
Date
Msg-id 737og9$v32j@dmzms99902.na.baesystems.com
Whole thread Raw
Responses Re: schema name in SQL statement.
List pgsql-general
Tree view 
I have to explicitly specify the schema name to make SQL statement to
work.
Can I set the schema before the query, or set a default schema?
My current statement:
"SELECT col FROM schema.table"
I like to be able to use generic SQL statement like:
"SELECT col FROM table"

pgsql-general by date:

Previous
From: Glen Parker
Date:
Subject: Re: WAL archiving to network drive
Next
From: aklaver@comcast.net (Adrian Klaver)
Date:
Subject: Re: schema name in SQL statement.