Re: find column name that has under score (_)

[akp geek <akpgeek@xxxxxxxxx>]

thanks . It worked

Regards

On Thu, Feb 17, 2011 at 2:05 PM, RadosÅaw Smogura <rsmogura@xxxxxxxxxxxxxxx> wrote:

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.