Postgres Pro
Downloads
Home   >   mailing lists

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

From lrnr
Subject How to find a column name
Date
Msg-id 86sm9inb1l.fsf@znain.com
Whole thread Raw
Responses Re: How to find a column name  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Peter Lang
Date:
Subject: Re: psql error - "unrecognizable command" V8.0.0 beta
Next
From: "Rolf Østvik"
Date:
Subject: Re: Spacing in output