Re: How to find a column name - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: How to find a column name
Date
Msg-id 200409181614.56806.peter_e@gmx.net
Whole thread Raw
In response to How to find a column name  (lrnr <ns@nospam.com>)
List pgsql-general
lrnr wrote:
> For example, I want to find all columns that have a name containing
> the string 'USER', in any table. How can I do this?

SELECT * FROM information_schema.columns WHERE column_name LIKE
'%USER%';

--
Peter Eisentraut
http://developer.postgresql.org/~petere/


pgsql-general by date:

Previous
From: Edmund Bacon
Date:
Subject: Re: Default value if query returns 0 rows?
Next
From: Tim Penhey
Date:
Subject: pg_restore peculiarities