Postgres Pro
Downloads
Home   >   mailing lists

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

From hubert depesz lubaczewski
Subject Re: find column name that has under score (_)
Date
Msg-id 20110217195529.GA7377@depesz.com
Whole thread Raw
In response to find column name that has under score (_)  (akp geek <akpgeek@gmail.com>)
List pgsql-general
Tree view 
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@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

pgsql-general by date:

Previous
From: Geoffrey Myers
Date:
Subject: Re: disable triggers using psql
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: disable triggers using psql