postgres=# create user scott;
CREATE ROLE
postgres=# create database scottdb owner scott;
CREATE DATABASE
postgres=# \c scottdb scott
You are now connected to database "scottdb" as user "scott".
scottdb=> create table dog (a int);
CREATE TABLE
scottdb=> \d
       List of relations
 Schema | Name | Type  | Owner
--------+------+-------+-------
 public | dog  | table | scott
(1 row)

scottdb=> create temporary table dog (a int, b int);
CREATE TABLE
scottdb=> \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 TABLE
scottdb=> \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 TABLE
scottdb=> \d
No relations found.
scottdb=>