How to give SELECT access to all columns of all tables except one column?

Question

PostgreSQL

If database: 150 tables. Among them is a user table with a password field. It is necessary to create such a user who would be able to make SELECT queries to all tables and all columns, except for user.password. Moreover, he must have access to the user table.
Is it possible to do this without listing all tables? Thank you.

Answer 1

you can create a function that will return this table without the required field, then prohibit the user from using the table, but allow the user to use the function.