select current_setting('search_path') union select version();
Regards
Rodrigo
On 08/01/2011 06:07 PM, Konstantin Izmailov wrote:
Is it possible instead of executing following two statements:
SHOW search_path; SELECT version();
to execute just one statement returning both search_path and version?
I'm using Postgres 9.0 and need the result either as two tuples or two
fields...
Could you suggest how to rewrite the two statements?
Thx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
