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