KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I would like to use the psql "\copy" command to pull data from a tab-delimited file into Postgres. I'm using this command: \copy cm_state from 'state.data' with delimiter '\t' null as ; But I'm getting this warning (the table actually loads fine): WARNING: nonstandard use of escape in a string literal LINE 1: COPY cm_state FROM STDIN DELIMITER '\t' NULL AS ';' HINT: Use the escape string syntax for escapes, e.g., E'\r\n'. How do I specify a tab if '\t' is not correct?
Tags (comma-separated)
Save Edits
Cancel