show databases and tables in postgress code example Example 1: postgresql list db postgres=# \l Example 2: show details of table postgres postgres=# \d tablename;