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

From: akp geek <akpgeek(at)gmail(dot)com>
To: Radosław Smogura <rsmogura(at)softperience(dot)eu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: find column name that has under score (_)
Date: 2011-02-17 19:07:25
Message-ID: AANLkTimDkJX3iHuisXkRhV9_6MCnJJWtqfuLx+W7UcBg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

thanks . It worked

Regards

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

> akp geek <akpgeek(at)gmail(dot)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.
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2011-02-17 19:07:53 Re: find column name that has under score (_)
Previous Message Radosław Smogura 2011-02-17 19:05:22 Re: find column name that has under score (_)