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

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: akp geek <akpgeek(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: find column name that has under score (_)
Date: 2011-02-17 19:55:29
Message-ID: 20110217195529.GA7377@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Feb 17, 2011 at 01:55:46PM -0500, akp geek wrote:
> 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?

where column_name ~ '_'

Best regards,

depesz

--
Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/
jid/gtalk: depesz(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Geoffrey Myers 2011-02-17 20:06:02 Re: disable triggers using psql
Previous Message akp geek 2011-02-17 19:09:47 Re: find column name that has under score (_)