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

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

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message akp geek 2011-02-17 19:07:25 Re: find column name that has under score (_)
Previous Message akp geek 2011-02-17 18:55:46 find column name that has under score (_)