Skip to content

Instantly share code, notes, and snippets.

View frankxiao008's full-sized avatar

Saihong(Frank) Xiao frankxiao008

15 followers · 55 following
View GitHub Profile
@frankxiao008
frankxiao008 / postgres-import-export-csv.md
Created March 19, 2019 12:41 — forked from nepsilon/postgres-import-export-csv.md
Importing and Exporting CSV files with PostgreSQL — First published in fullweb.io issue #19

Importing and exporting CSV files with PostgreSQL

Let’s see how to use PostgreSQL to import and export CSV files painlessly with the COPY command.

Import CSV into table t_words:

COPY t_words FROM '/path/to/file.csv' DELIMITER ',' CSV;

You can tell quote char with QUOTE and change delimiter with DELIMITER.

@frankxiao008
frankxiao008 / gist:dd189e5b1e6352ac523e4064b24c1362
Created February 8, 2019 15:57 — forked from CristinaSolana/gist:1885435
Keeping a fork up to date

1. Clone your fork:

git clone [email protected]:YOUR-USERNAME/YOUR-FORKED-REPO.git

2. Add remote from original repository in your forked repository:

cd into/cloned/fork-repo
git remote add upstream git://github.com/ORIGINAL-DEV-USERNAME/REPO-YOU-FORKED-FROM.git
git fetch upstream