Home > mailing lists

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

From	akp geek
Subject	Re: find column name that has under score (_)
Date	February 17, 2011 15:07:35
Msg-id	AANLkTimDkJX3iHuisXkRhV9_6MCnJJWtqfuLx+W7UcBg@mail.gmail.com Whole thread Raw
In response to	Re: find column name that has under score (_) (Radosław Smogura <rsmogura@softperience.eu>)
List	pgsql-general

Tree view

thanks . It worked

Regards

On Thu, Feb 17, 2011 at 2:05 PM, Radosław Smogura <rsmogura@softperience.eu> wrote:

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:

From: Radosław Smogura
Date: 17 February 2011, 15:05:21
Subject: Re: find column name that has under score (_)

From: "David Johnston"
Date: 17 February 2011, 15:08:29
Subject: Re: find column name that has under score (_)

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

Previous

Next