# su - postgres -bash-4.2$ psql psql (9.6.17) Type "help" for help. postgres=# \l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges ------------+--------------+----------+-------------+-------------+----------------------- dbpostgres | betapostgres | UTF8 | UTF-8 | UTF-8 | pb_storage | pb_storage | UTF8 | UTF-8 | UTF-8 | postgres | postgres | UTF8 | UTF-8 | UTF-8 | template0 | postgres | UTF8 | UTF-8 | UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | UTF-8 | UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres (5 rows) postgres=# \c dbpostgres You are now connected to database "dbpostgres" as user "postgres". dbpostgres=# \dt List of relations Schema | Name | Type | Owner --------+------+-------+---------- public | pgqs | table | postgres (1 row) dbpostgres=# SELECT pg_tables.tablename, pgqs.created_at dbpostgres-# FROM pg_tables dbpostgres-# INNER JOIN pgqs dbpostgres-# ON pg_tables.tablename = pgqs.tablename; ERROR: column pgqs.tablename does not exist LINE 4: ON pg_tables.tablename = pgqs.tablename;