Skip to content

prasertcbs/postgresql

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

93 Commits
img
img
 
 
README.md
README.md
 
 
akb48.tar
akb48.tar
 
 
amphur.json
amphur.json
 
 
amphur.sql
amphur.sql
 
 
amphur_j.sql
amphur_j.sql
 
 
amphur_json.sql
amphur_json.sql
 
 
animal_crossing.tar
animal_crossing.tar
 
 
anime_no_review_text.tar
anime_no_review_text.tar
 
 
baskin.sql
baskin.sql
 
 
billionaire.sql
billionaire.sql
 
 
cat.sql
cat.sql
 
 
covid19.psql
covid19.psql
 
 
create yummi order_dnz.psql
create yummi order_dnz.psql
 
 
create_province_with_data.sql
create_province_with_data.sql
 
 
daily_sales.sql
daily_sales.sql
 
 
disney.psql
disney.psql
 
 
disney.tar
disney.tar
 
 
disney_tables.xlsx
disney_tables.xlsx
 
 
dog.sql
dog.sql
 
 
drink.sql
drink.sql
 
 
fifa.psql
fifa.psql
 
 
fifa2021.sql
fifa2021.sql
 
 
hotel_table.tar
hotel_table.tar
 
 
icecream_brand.tar
icecream_brand.tar
 
 
icecream_ts.sql
icecream_ts.sql
 
 
imdb1000.psql
imdb1000.psql
 
 
imdb_small.tar
imdb_small.tar
 
 
marvel.tar
marvel.tar
 
 
mcdonald.csv
mcdonald.csv
 
 
mcdonald.json
mcdonald.json
 
 
mcdonald.sql
mcdonald.sql
 
 
movie_meta.sql
movie_meta.sql
 
 
movie_ts.sql
movie_ts.sql
 
 
movie_ts_array_json.sql
movie_ts_array_json.sql
 
 
netflix.sql
netflix.sql
 
 
northwind.tar
northwind.tar
 
 
nutrition.tar
nutrition.tar
 
 
olympian_table.tar
olympian_table.tar
 
 
order_dnz.csv
order_dnz.csv
 
 
pokemon.sql
pokemon.sql
 
 
province.sql
province.sql
 
 
province2.json
province2.json
 
 
province_amphur.json
province_amphur.json
 
 
province_amphur_th_en.sql
province_amphur_th_en.sql
 
 
province_j2.sql
province_j2.sql
 
 
quotes3000.csv
quotes3000.csv
 
 
quotes3000.sql
quotes3000.sql
 
 
rotten_tomato.sql
rotten_tomato.sql
 
 
saturn.tar
saturn.tar
 
 
social_media_followers.sql
social_media_followers.sql
 
 
spotify_chart.sql
spotify_chart.sql
 
 
starbucks.sql
starbucks.sql
 
 
starbucks.tar
starbucks.tar
 
 
starbucks_tables.xlsx
starbucks_tables.xlsx
 
 
tmdb.tar
tmdb.tar
 
 
tmdb_json.sql
tmdb_json.sql
 
 
yummi.tar
yummi.tar
 
 
yummi2.tar
yummi2.tar
 
 
yummi_create_fk_ck_idx.psql
yummi_create_fk_ck_idx.psql
 
 
yummi_denormalized.xlsx
yummi_denormalized.xlsx
 
 
yummi_pk_fk_ck_idx.tar
yummi_pk_fk_ck_idx.tar
 
 
yummi_plain.tar
yummi_plain.tar
 
 
yummi_tables.xlsx
yummi_tables.xlsx
 
 

Repository files navigation

PostgreSQL

แหล่งรวม PostgreSQL database สำหรับการเรียนรู้

การ backup/restore ฐานข้อมูล

IMAGE ALT TEXT HERE

  1. ทำการสร้าง database ใหม่ขึ้นมา
  2. restore .tar ไฟล์ไปยัง database ที่สร้างขึ้น

pg_restore tips

print summarized TOC of the archive

pg_restore -l disney.tar

convert pg_backup tar/custom format (with compression) to sql script

pg_restore -f disney.sql disney.tar

About

PostgreSQL sample database, json, csv, tsv files

Resources

Readme
Activity

Stars

1 star

Watchers

1 watching

Forks

1 fork
Report repository

Releases

No releases published

Packages

 
 
 

Contributors