/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 vote202 views2 answers
Moonspell (@moonspellofficial) • Instagram photos and videoswww.instagram.com › moonspellofficial 61.4k Followers, 619 Following, 2421 Posts - See Instagram photos and videos from Moonspell (@moonspellofficial)
TypeScript
4 votes202 views2 answers
Hosts file
TypeScript
0 vote243 views1 answer
Dynamic index in typescript
TypeScript
0 vote196 views1 answer
While converting HTML 4 elements to HTML 5 semantic elements, <div class="post"> will be converted into
TypeScript
0 vote200 views1 answer
What are the used of curly brackets in react functions
TypeScript
0 vote194 views1 answer
From date and to date validation in angular 8
TypeScript
0 vote185 views1 answer
Extending a type in typescript
TypeScript
19 votes192 views5 answers
Cannot use import statement outside a module typescript
TypeScript
57 votes545 views3 answers
How to check list of open ports in linux
TypeScript
11 votes188 views1 answer
Remove dots from ul li
TypeScript