PostgreSQL Table Import/Export from and to CSV File

Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

David.Poole SSC Guru Points: 76035 More actions · Answer 1

When using an AWS RDS instance the file option of the COPY statement is not supported, however you can use STDIN.

cat my_file.csv|psql -c "copy my_schema.my_table(id,name,description) from STDIN  with csv header"

Copying to a file can be achieved using STDOUT