Discussions

Ask a Question
Back to All

COPY FROM DOCUMENTATION

In the documentation, the only info re: COPY FROM in psql is:

Through a Client
Once you connect a database client to bit.io, you can upload data by making a SQL "INSERT INTO" or "COPY FROM" query.

I've tried multiple attempts always with the same error:
command: COPY table_name FROM '/path-to-csv/file.csv';

error:

ERROR:  COPY to/from a filename is not supported
DETAIL:  Visit docs.bit.io for more detail how to COPY
HINT:  Use STDIN or STDOUT instead

Please could you tell me what I'm doing wrong and/or add more details to the documentation.

Thanks