FW: pgscript & select - Mailing list pgadmin-support

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?

Doug Little

Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide

500 W. Madison, Suite 1000  Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741

Douglas.Little@orbitz.com

   orbitz.com | ebookers.com | hotelclub.com | cheaptickets.com | ratestogo.com | asiahotels.com