Problem with COPY FROM with PHP in postgresql

Question

I have some big .csv files and I am trying to put it into database. I am using this construction:

COPY table_name(column1, column2, column..., columnN) FROM stdin;
column1 column2 column... column N
column1 column2 column... column N
column1 column2 column... column N
column1 column2 column... column N
\.

But after use \i function in CLI I got that:

ERROR:  end-of-copy marker corrupt

This is not a problem with end marker, but with encoding. If I open this file in VIM and will save it again, everything is OK, but without this operations I got this error all the time. What can I do in PHP (with PHP I create those files) to fix that? If this is for sure problem with encoding?

Community · Accepted Answer · 2023-11-17 20:08:53Z

1

Is there also a newline after the \. ? Check the example in the PHP-manual for pg_put_line() as well and take notice of the \n at the end.

edited Nov 17, 2023 at 20:08

CommunityBot

11 silver badge

answered Feb 17, 2011 at 10:46

Frank Heikens

129k26 gold badges157 silver badges153 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sobhan · Accepted Answer · 2020-08-14 12:40:40Z

0

There is a easy solution for this, you only need to press "Enter" after "\." and then save your file and try again, it will resolve your issue.

answered Aug 14, 2020 at 12:40

Sobhan

1,4781 gold badge21 silver badges37 bronze badges

Collectives™ on Stack Overflow

Problem with COPY FROM with PHP in postgresql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related