/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 vote169 views1 answer
Whats my country
TypeScript
1 vote137 views1 answer
Ionic Can't resolve all parameters for
TypeScript
0 vote196 views2 answers
Array objects to array of one property
TypeScript
1 vote175 views1 answer
How to create multiple sheets in excel using python in openpyxml
TypeScript
0 vote191 views2 answers
Kotlin get first n elements from list
TypeScript
14 votes180 views6 answers
How to add two lists in python
TypeScript
0 vote167 views1 answer
React hooks typescript function return and receive
TypeScript
0 vote158 views1 answer
Typescript event emitter
TypeScript
0 vote168 views1 answer
'create' is deprecated
TypeScript
7 votes171 views2 answers
Firestore increment field
TypeScript