\. in sql file?

Question

PHP

Hello. I did a database dump, it has this line:

COPY public.tbl (id, score, user_id, created_at, updated_at)
FROM stdin;
\.

If the dump is imported using the pgsql utility, everything works fine, but if through the php utility that reads the file and executes queries using pdo, it swears at \.
Please tell me what does \ mean. and how to win it in php?

Answer 1

using the pgsql utility

I don't know those. What is this utility, what does it do, how does it do it?
This marks the end of the data for COPY. https://www.postgresql.org/docs/current/sql-copy.html
emnip, php can't copy from stdin as queries at all, only as PDO::pgsqlCopyFromArray functions for PDO or pg_put_line, pg_end_copy for php-postgresql extension.