thanks . It worked Regards
On Thu, Feb 17, 2011 at 2:05 PM, Radosław Smogura <rsmog...@softperience.eu>wrote: > 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. >
