Postgres Pro
Downloads
Home   >   mailing lists

Re: find column name that has under score (_) - Mailing list pgsql-general

From Radosław Smogura
Subject Re: find column name that has under score (_)
Date
Msg-id 201102172005.23080.rsmogura@softperience.eu
Whole thread Raw
In response to find column name that has under score (_)  (akp geek <akpgeek@gmail.com>)
Responses Re: find column name that has under score (_)
List pgsql-general
Tree view 
akp geek <akpgeek@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.

pgsql-general by date:

Previous
From: akp geek
Date:
Subject: find column name that has under score (_)
Next
From: akp geek
Date:
Subject: Re: find column name that has under score (_)