Skip to content

Instantly share code, notes, and snippets.

@springcoil

springcoil/Postgres_Fun

Created June 18, 2014 12:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save springcoil/270b41f49038c8383244 to your computer and use it in GitHub Desktop.
Save springcoil/270b41f49038c8383244 to your computer and use it in GitHub Desktop.
Download ZIP
CSVKit and PostgreSQL
Raw
Postgres_Fun
csvsql --db postgresql:///test1 --insert Problem_Set_Operations_Research.csv
# I was having some trouble getting a csv file inserted into a Postgres Database. The above line worked.
\dt
#Shows the tables in a particular database
\connect test1
#Connects to a database with a particular name in the case above "test1"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment