/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 vote211 views1 answer
Font type css system
TypeScript
0 vote280 views1 answer
The pipe 'json' could not be found!
TypeScript
0 vote211 views1 answer
?In static pages, the contents are fluid and changeable (e.g., rotating banners).
TypeScript
0 vote243 views1 answer
How to register a static assets folder spring boot
TypeScript
-1 vote222 views1 answer
Find number of digits that changed after addition of 1
TypeScript
4 votes210 views1 answer
ERR_TOO_MANY_REDIRECTS wordpress
TypeScript
1 vote221 views1 answer
What is the name of belt around the orbits of earth and mars
TypeScript
5 votes214 views1 answer
Benefits of multiprogramming
TypeScript
1 vote208 views1 answer
Npm run serve https
TypeScript
2 votes211 views1 answer
Add elements to middle of array using splice
TypeScript