/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

1 vote119 views3 answers
Linux split mp4 into 2 parts by time
TypeScript
0 vote132 views1 answer
Ts pipe function
TypeScript
1 vote109 views1 answer
How to pring events in pygame
TypeScript
13 votes109 views6 answers
React native typescript
TypeScript
0 vote110 views1 answer
Typescript init string array
TypeScript
1 vote112 views1 answer
Script to see what tkinter fonts installed on system
TypeScript
1 vote145 views1 answer
Typescript how to add a property to an object
TypeScript
1 vote110 views1 answer
Ts class static function call inside class extends
TypeScript
0 vote112 views1 answer
Could not resolve all artifacts for configuration ':classpath'.
TypeScript
0 vote110 views1 answer
Nestjs Monogdb Handel Catch Error
TypeScript