/TypeScript/COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as psql's \copy.

COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as psql's \copy.

Assuming the psql command-line tool, you may use \copy instead of copy.

\copy opens the file and feeds the contents to the server, whereas copy tells the server the open the file itself and read it, which may be problematic permission-wise, or even impossible if client and server run on different machines with no file sharing in-between.

Under the hood, \copy is implemented as COPY FROM stdin and accepts the same options than the server-side COPY.

Similar codes

0 vote213 views1 answer
How to run springboots processbuilder
TypeScript
0 vote175 views1 answer
Whats app link target blank
TypeScript
0 vote197 views1 answer
What will be the result of the cp /etc/hosts . command?
TypeScript
1 vote237 views1 answer
Type annotations can only be used in TypeScript files.
TypeScript
21 votes221 views2 answers
Voting results 2020 live
TypeScript
2 votes190 views1 answer
Expected 2 arguments but got 1. viewchild angular
TypeScript
9 votes181 views1 answer
Typescript check if element in array
TypeScript
47 votes276 views9 answers
Cannot be loaded because running scripts is disabled on this system
TypeScript
1 vote206 views1 answer
Whats ruby used for
TypeScript
3 votes211 views1 answer
Find a value in list of objects in c#
TypeScript