Module14_Moving_Data

Question 1

how to load flat files to postgres and EDb

Answer 1

COPY for postgres and EDB*Loader for EDB

Question 2

how to copy data from table to file

Answer 2

with the COPY TO command
copy table_name (column_name) to ‘/tmp/location_file.csv’ with CSV HEADER; HEADER will include column names at the top.

Question 3

how to copy data file table to table

Answer 3

with COPY FROM command:
copy table_name (column_name) from ‘/tmp/location_file.csv’ with CSV HEADER; HEADER will include column names at the top.