Trying to copy text file to table postgresql

Question

Trying to save a text file from desktop

copy my_notes(notes) from  '/root/desktop/test_note.txt'

It shows this error..

ERROR: extra data after last expected column

CONTEXT: COPY my_notes, line 3: " cher"

I'm a newbie in postgresql

score 2 · Answer 1 · answered Mar 05 '14 at 06:44

2

COPY expects tab-separated data, with newlines separating rows.

It isn't suitable for just loading a text file into a field. To do that, I suggest using a simple script, say python and psycopg2.

answered Mar 05 '14 at 06:44

Craig Ringer

307,061
76
688
778

score 0 · Answer 2 · edited May 23 '17 at 11:57

0

To read a plain text from a file, there is also pg_read_file() - reserved for superusers, though, because of potential security implications. Details in this related answer:
Read data from a text file inside a trigger

edited May 23 '17 at 11:57

Community

1
1

answered Mar 05 '14 at 07:46

Erwin Brandstetter

605,456
145
1,078
1,228

Trying to copy text file to table postgresql

2 Answers2