/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 vote175 views1 answer
Rewrite requests htaccess
TypeScript
0 vote215 views1 answer
Hsts wordpress
TypeScript
0 vote190 views1 answer
UTorrent Default Download Folder - Linux
TypeScript
8 votes180 views6 answers
Dotenv typescript
TypeScript
10 votes210 views3 answers
Foreach typescript
TypeScript
0 vote177 views1 answer
How to get the corners of 2 points on a matrix
TypeScript
0 vote185 views1 answer
Ionic iosa app not making requests to server
TypeScript
0 vote191 views2 answers
How to check if a string contains only alphabets and space in java
TypeScript
3 votes213 views1 answer
Intersection between two sets python
TypeScript
0 vote171 views1 answer
Property control in spotfire doest not exist on abstractcontrol
TypeScript