PostgreSQL Sample Database

# unzip dvdrental.zip -- 만약 unzip 패키지 설치가 안되어 있다면 ? -- yum install -y unzip # chown opensql:opensql dvdrental.tar # mv dvdrental.tar /opensql/ # su -opensql $ psql -U postgres -d postgres -c "create database dvdrental;" $ pg_restore -U postgres -d dvdrental /opensql/dvdrental.tar

$ psql -U postgres -d dvdrental psql (14.6) Type "help" for help. dvdrental=# \dt List of relations Schema | Name | Type | Owner --------+---------------+-------+---------- public | actor | table | postgres public | address | table | postgres public | category | table | postgres public | city | table | postgres public | country | table | postgres public | customer | table | postgres public | film | table | postgres public | film_actor | table | postgres public | film_category | table | postgres public | inventory | table | postgres public | language | table | postgres public | payment | table | postgres public | rental | table | postgres public | staff | table | postgres public | store | table | postgres (15 rows) dvdrental=# \ds List of relations Schema | Name | Type | Owner --------+----------------------------+----------+---------- public | actor_actor_id_seq | sequence | postgres public | address_address_id_seq | sequence | postgres public | category_category_id_seq | sequence | postgres public | city_city_id_seq | sequence | postgres public | country_country_id_seq | sequence | postgres public | customer_customer_id_seq | sequence | postgres public | film_film_id_seq | sequence | postgres public | inventory_inventory_id_seq | sequence | postgres public | language_language_id_seq | sequence | postgres public | payment_payment_id_seq | sequence | postgres public | rental_rental_id_seq | sequence | postgres public | staff_staff_id_seq | sequence | postgres public | store_store_id_seq | sequence | postgres (13 rows) dvdrental=# \dv List of relations Schema | Name | Type | Owner --------+----------------------------+------+---------- public | actor_info | view | postgres public | customer_list | view | postgres public | film_list | view | postgres public | nicer_but_slower_film_list | view | postgres public | sales_by_film_category | view | postgres public | sales_by_store | view | postgres public | staff_list | view | postgres (7 rows)