/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 vote318 views1 answer
Get number of objects in enum c++
TypeScript
1 vote295 views1 answer
Size of list applescript
TypeScript
0 vote326 views1 answer
Beautifulsoup search for elements with attributes
TypeScript
3 votes318 views1 answer
Squash commits in remote branch
TypeScript
0 vote308 views1 answer
Font awesome reeact js example
TypeScript
0 vote295 views2 answers
Append contents of one file to another
TypeScript
12 votes298 views1 answer
How check is file exist linux
TypeScript
1 vote314 views1 answer
Difference between dictionary and sets in python
TypeScript
0 vote317 views1 answer
Useappdispatch
TypeScript
6 votes355 views1 answer
Angular forkjoin
TypeScript