akp geek <akpgeek@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
