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 = '@datab
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 out