block by palewire 91539314f475815f30dba978a88f4370

Simple COPY examples

Simple COPY examples

Two simple examples of quickly loading data into PostgreSQL with the COPY command.

Much more sophisticated stuff is possible. Refer to the official docs and consider adopting a wrapper like django-postgres-copy for more complicated tasks.

cloud.sh

copy.sql

count.sql

create.sql

data.csv

drop.sql

localhost.sh