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