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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
