On Fri, 2006-06-16 at 12:57, LLC wrote: > Hi List; > > I found documentation that talks about untrusted perl here: > http://www.postgresql.org/docs/8.1/interactive/plperl-trusted.html > > However I do not know how to install/use untrusted perl. > > Can someone point me in the right direction? > > Thanks in advance... > Here's a dirt simple shell script to make a set for everything in the public schema. It's not pretty, but it seems to work on 7.4.x echo "create temp sequence tc;SELECT 'set add table (set id=1, origin=1, id='||nextval('tc')||', fully qualified name = ''public.'||c.relname||'\', comment=\'\');' as \"Name\" FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_user u ON u.usesysid = c.relowner LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE n.nspname='public' and c.relkind IN ('r') AND n.nspname NOT IN ('pg_catalog', 'pg_toast') AND pg_catalog.pg_table_is_visible(c.oid) order by 1;drop sequence tc;"|psql stage_reporting
