/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 vote272 views1 answer
Components react to hooks
TypeScript
0 vote257 views1 answer
Python select only first elements of a 2d array
TypeScript
1 vote265 views1 answer
From sklearn.datasets import fetch_mldata error
TypeScript
1 vote251 views1 answer
How to get absolute value of elements of list in python
TypeScript
0 vote267 views1 answer
Module svg typescript
TypeScript
0 vote250 views1 answer
Failed to enumerate objects in the container access is denied windows 10
TypeScript
3 votes355 views1 answer
Google sheets remove first character
TypeScript
0 vote267 views1 answer
.htaccess Preventing requests with invalid characters
TypeScript
1 vote246 views1 answer
Change textinputlayout color
TypeScript
0 vote248 views1 answer
Peer of typescript@>=2.8.0
TypeScript