How to find a column name

From: lrnr <ns(at)nospam(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to find a column name
Date: 2004-09-16 03:32:21
Message-ID: 86sm9inb1l.fsf@znain.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

Is there in Postgresql something like the all_tab_columns table in
ORACLE? How can I find if a column name exists in the database?

For example, I want to find all columns that have a name containing the
string 'USER', in any table. How can I do this?

--
lrnr

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jerome Lyles 2004-09-16 04:15:11 Re: Spacing in output
Previous Message Greg Stark 2004-09-16 03:28:05 Re: what is flushed?