How to search for a variable name in PostgreSQL?

Question

I want to search for a particular variable name in ‘PostgreSQL’ database. Similar to the following ‘Teradata’ query

Select TableName, ColumnName from
DBC.Columns
Where ColumnName like (‘%profile%’)

Is there a similar query in PostgreSQL?

Answer 1

Postgres documentation

SELECT table_name,column_name
FROM information_schema.columns
WHERE column_name  like '%profile%'