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.