I generally use something like this to generate the SET ADD TABLE and SET ADD
SEQUENCE output:
CREATE SEQUENCE table_tmp_seq;
CREATE SEQUENCE sequence_tmp_seq;
SELECT 'SET ADD TABLE (SET id = 1, origin = 1, id = ' ||
nextval('table_tmp_seq') || ', FULL QUALIFIED NAME = \'' || schemaname || '.'
|| tablename || '\', comment=\'' || schemaname || '.' || tablename || '
TABLE\');' FROM pg_tables WHERE schemaname NOT IN ('information_schema',
'pg_catalog');
SELECT 'SET ADD SEQUENCE (SET id = 1, origin = 1, id = ' ||
nextval('sequence_tmp_seq') || ', FULL QUALIFIED NAME = \'' || n.nspname || '.'
|| c.relname || '\', comment=\'' || n.nspname || '.' || c.relname || '
TABLE\');' FROM pg_class c, pg_namespace n WHERE c.relnamespace = n.OID AND
c.relkind = 'S' AND c.relname NOT IN ('table_tmp_seq', 'sequence_tmp_seq');
DROP SEQUENCE table_tmp_seq;
DROP SEQUENCE sequence_tmp_seq;
On Tue, 6 Feb 2007, Ashish Karalkar wrote:
> Hello All,
> Can anybody suggest me the work around method to avoid manually writting ADD
> TABLE and ADD SEQUENCE
> Because I have around 500 table and 500 sequences.
> With Regards
> ashish...
>
> _______________________________________________
> Slony1-general mailing list
> [email protected]
> http://gborg.postgresql.org/mailman/listinfo/slony1-general
>
>
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
