On Thu, Feb 17, 2011 at 01:55:46PM -0500, akp geek wrote: - 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
select table_schema,table_name, column_name from information_schema.columns where column_name like '%\\_%'; seems to do the trick. Dave -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
