Re: FW: pgscript & select

On Saturday 23 January 2010 18:17:15 Little, Douglas wrote:
> It's not clear to me from the doc that pgscript doesn't work with select
> statements. I'm trying to run
>
>
> set @databasename='orbitz_hist_schema_hods' ;
>
> select *
> from pg_catalog.pg_namespace n1
> where n1.nspname = '@databasename'
> ;
>
> And when executed, I get no results in the data output tab.
> Is this supposed to work?
>

You should inser the data from the SELECT into a variable and then print it.

Something like that should work:

SET @databasename='orbitz_hist_schema_hods' ;

SET @data = select *
from pg_catalog.pg_namespace n1
where n1.nspname = '@databasename';

PRINT @data;

This way you will get all the data returned by the SELECT statemen.
For a specific row and column you then use

PRINT @data[<row>][<column>];

Regards,
Jure