Postgres Bulk Load - tmp data file location on a server

[Drussek]

I would like to switch from loading data into Postgres to bulk load. Unfortunately, I must first provide information on how and where on the server the data goes.

I know that files and COPY are used but specifically where on the postgres server do the files go and are they for sure deleted after loading?

I have searched the documentation as well as the community and nowhere is there a word about this.

Does anyone of you perhaps have this information?

[Drussek · Accepted solution]

I installed Postgresql locally and found an answare in a log.
In fact, no temporary file is created, because there is used STDIN as an input.

So COPY is done by calling:

---

COPY "public"."bulkload" from STDIN (DELIMITER ',', FORMAT csv, QUOTE '"', NULL '', ENCODING 'UTF8');

That is an information I wanted to find.