/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 vote277 views1 answer
More than one custom value accessor matches form control with unspecified name attribute
TypeScript
0 vote254 views1 answer
Typescript sort number array descending
TypeScript
0 vote246 views1 answer
Real time charts in flutter
TypeScript
-1 vote245 views1 answer
Union type property does not exist
TypeScript
2 votes229 views1 answer
UseStae with array of strings typescript
TypeScript
2 votes263 views1 answer
Ts date format dd/mm/yyyy
TypeScript
0 vote245 views1 answer
Array with objects read element with the lowest value
TypeScript
0 vote250 views1 answer
Install snowpack
TypeScript
0 vote274 views1 answer
Instruments du marché monétaire
TypeScript
1 vote291 views1 answer
Typescript override interface property
TypeScript