akp geek <akpg...@gmail.com> Thursday 17 February 2011 19:55:46 > 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.
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
