How to view all tables in pgsql?

You can use the following command to view all tables in the current database:

\dt

This will display all the tables in the current database along with their relevant information such as table name, schema, type, etc. You can also use the following command to view all tables in a specific schema:

\dt schema_name.*

Please make sure you are connected to the database you want to query before using these commands.