Discussions
COPY FROM DOCUMENTATION
5 months ago by Frederique Lemieux
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