Quick Links

find column name that has under score (_)

From:	akp geek <akpgeek(at)gmail(dot)com>
To:	pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject:	find column name that has under score (_)
Date:	2011-02-17 18:55:46
Message-ID:	AANLkTinX5oyb=WtB3poaF9CnLhAwbrhA8GQ=8H23Lar9@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

Responses

Re: find column name that has under score (_) at 2011-02-17 19:05:22 from Radosław Smogura
Re: find column name that has under score (_) at 2011-02-17 19:07:53 from David Johnston
Re: find column name that has under score (_) at 2011-02-17 19:09:09 from David Kerr
Re: find column name that has under score (_) at 2011-02-17 19:55:29 from hubert depesz lubaczewski

Browse pgsql-general by date

	From	Date	Subject
Next Message	Radosław Smogura	2011-02-17 19:05:22	Re: find column name that has under score (_)
Previous Message	Dmitriy Igrishin	2011-02-17 17:42:31	Re: SELECT INTO array[i] with PL/pgSQL