Hi, I wonder if anyone can help. I'd like to execute a SQL query that performs an action on all the (unrelated) tables that I select. The following query doesn't work, but the subselect (which works) shows what I'm trying to do. All tables have an identical column called id_num.
delete from (select tablename from pg_tables where schemaname = 'public') where id_num = null I'd appreciate any advice. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
