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