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
