Character attributes are aligned on single-byte boundaries. On most other machines, all attributes larger than 1 byte are aligned on four-byte boundaries. The data is shown after filtering through the Unix utility od -c . All the rows have a null value in the third field. It does invoke triggers, however.
COPY stops operation at the first error.
This should not lead to problems in the event of a COPY FROM , but the target relation will, of course, be partially modified in a COPY TO . In general, the full pathname as it would appear to the backend server machine should be used when specifying files to be copied. Files used as arguments to COPY must reside on or be accessible to the database server machine by being either on local disks or on a networked file system. There is no COPY statement in SQL92.