How to find a column name

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