On 10/3/07, Laurent ROCHE <[EMAIL PROTECTED]> wrote: Would this work:
SELECT 'TRUNCATE TABLE ' || 'my_schema.' || c.relname ||', ' FROM pg_namespace nc, pg_class c WHERE c.relnamespace = nc.oid AND c.relkind IN ('r' ) AND nc.nspname = 'my_schema' ORDER BY relname ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly