/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

5 votes223 views2 answers
Lofi hip hop beats to study to
TypeScript
0 vote221 views1 answer
Angular minus date
TypeScript
0 vote224 views1 answer
How were sonnets used in rennaisance litireture
TypeScript
1 vote227 views1 answer
Roblox finding points around a circle using radius, center, and angle
TypeScript
0 vote248 views1 answer
How to append different lists in installed apps django
TypeScript
0 vote218 views1 answer
Replace multiple elements in a list python
TypeScript
0 vote234 views1 answer
Block robots from crawling
TypeScript
4 votes225 views2 answers
How to add a new propety into all documents in mongodb
TypeScript
-1 vote222 views2 answers
What are the components of the environment? Explain it along with the examples class 6
TypeScript
0 vote237 views1 answer
Wordpress number of posts by user
TypeScript