Re: COPY FROM STDIN instead of INSERT

>> Is it Ok to use COPY BINARY FROM STDIN instead of multiple INSERTs?

>I don't think I would use BINARY, it seems likely to be susceptible
>to changes in the underlying data type storage. From the docs:
>"To determine the appropriate binary format for the actual tuple data
>you should consult the PostgreSQL source

[skipped]

Yes, it's a problem, though it's solved already. I use BINARY for, say, initial data loading.

>AFIAK, the locking semantics are the same as INSERT, i.e., it
>does not lock the entire table or anything like that. Since it would
>allow transactions that insert data to finish faster, it should
>actually work better under high concurrency.

Do hope that's right.

Thanks.

--
Best regards
Ilja Golshtein