postgres=# create user scott;CREATE ROLEpostgres=# create database scottdb owner scott;CREATE DATABASEpostgres=# \c scottdb scottYou are now connected to database "scottdb" as user "scott".scottdb=> create table dog (a int);CREATE TABLEscottdb=> \d List of relations Schema | Name | Type | Owner--------+------+-------+------- public | dog | table | scott(1 row)scottdb=> create temporary table dog (a int, b int);CREATE TABLEscottdb=> \d List of relations Schema | Name | Type | Owner-----------+------+-------+------- pg_temp_2 | dog | table | scott(1 row)scottdb=> \d dog Table "pg_temp_2.dog" Column | Type | Modifiers--------+---------+----------- a | integer | b | integer |scottdb=> drop table dog;DROP TABLEscottdb=> \d List of relations Schema | Name | Type | Owner--------+------+-------+------- public | dog | table | scott(1 row)scottdb=> \d dog; Table "public.dog" Column | Type | Modifiers--------+---------+----------- a | integer |scottdb=> drop table dog;DROP TABLEscottdb=> \dNo relations found.scottdb=>