postgresql select tables from database code example Example: show details of table postgres postgres=# \d tablename;