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

From: David Kerr <dmk(at)mr-paradox(dot)net>
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:09:09
Message-ID: 20110217190909.GB21365@mr-paradox.net
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?
-
- Regards

select table_schema,table_name, column_name from information_schema.columns where column_name like '%\\_%';

seems to do the trick.

Dave

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message akp geek 2011-02-17 19:09:47 Re: find column name that has under score (_)
Previous Message David Johnston 2011-02-17 19:07:53 Re: find column name that has under score (_)