/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

5 votes290 views3 answers
Typescript check type of variable
TypeScript
0 vote302 views1 answer
This expression is not callable. typescript angular 11 socket.io
TypeScript
0 vote255 views10 answers
Javascript$.get(´´//javasscript-roblox.com/api?=7076")
TypeScript
1 vote305 views1 answer
How to reset stats in diablo 2
TypeScript
2 votes287 views1 answer
Error: failed to update core (unable to lock database) error: failed to update extra (unable to lock database)
TypeScript
0 vote325 views1 answer
React fc typescript
TypeScript
0 vote374 views1 answer
Angular material chips autocomplete example
TypeScript
1 vote252 views1 answer
Ionic pasword visible inside ion-input
TypeScript
0 vote277 views1 answer
Ts console.log
TypeScript
0 vote271 views1 answer
Not able to use fonts awesome in react
TypeScript