> Hi all - > > I am trying to write a query to find all the column names in > database that has a underscore in it (_) example souce_id. I know like will > not work , if where column_name like '%_%' Can you please help? > > Regards
Try SELECT * from pg_attribute where attname not like E'%\\_%' .... - i'm not familiar with this.