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.lit...@orbitz.com<mailto:douglas.lit...@orbitz.com>
[cid:image001.jpg@01CA9C1B.8B42A090] orbitz.com<http://www.orbitz.com/> |
ebookers.com<http://www.ebookers.com/> |
hotelclub.com<http://www.hotelclub.com/> |
cheaptickets.com<http://www.cheaptickets.com/> |
ratestogo.com<http://www.ratestogo.com/> |
asiahotels.com<http://www.asiahotels.com/>
<<inline: image001.jpg>>
