/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 vote156 views1 answer
Res.write prints html tags as text in express
TypeScript
0 vote145 views1 answer
Nativescript date input validation
TypeScript
1 vote169 views1 answer
Heterogeneous objects in java
TypeScript
0 vote205 views1 answer
Calling from a list elements in steps
TypeScript
0 vote149 views1 answer
Echarts is not defined
TypeScript
1 vote151 views1 answer
Reduce an array of objects to string
TypeScript
0 vote191 views1 answer
"What do the observed locations of gamma-ray bursts tell us about them?"
TypeScript
32 votes223 views6 answers
List without bullets html
TypeScript
-3 votes280 views3 answers
Ts warning Could not find a declaration file for module but runs
TypeScript
0 vote147 views1 answer
How to add multiple arguments in discord commands rewrite
TypeScript