Notes

Ujnotes — CC0 1.0

NULL and empty string ‘’ are entirely different.

NULL and empty string ‘’ are entirely different.

Escape ,

Enclose filed in quotes.

Escape “

Double quotes.

"value","another value","this is ""another"" value","no more, thanks".

Check null

Is [Not] Null.

Restart

Su.

First root up - or else you ?may? not be able to su postgres if postgres has no password.

Su postgres.

/opt/postgres/9.1/bin/pg_ctl reload -D /opt/postgres/9.1/data/

/opt/postgres/9.1/data/pg_hba.conf

Abort copy

CSV / Input.

\.[{New-Line}].

ctid

Auto generated row id.

0 for NULL

Collace.

Returns first non null param.