Changes

Jump to navigation Jump to search
448 bytes added ,  13:50, 15 May 2019
no edit summary
7. Replace "[ ]{2,}" with [leave blank] removes more than one spaces between two words
 
=Useful PostgreSQL Script=
 
Always load/unload data using the PostgreSQL specific copy function below. Always load tab-delimited data that is UTF-8 encoded, with PC or UNIX line endings, and that has a header row. NEVER DEVIATE FROM THIS.
 
Load using:
\COPY tablename FROM 'filename.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
Unload (copy to txt file) using:
\COPY tablename TO 'filename.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
241

edits

Navigation menu