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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to