GitHub - imreFitos/csvtopostgresql: Import CSV To Postgresql table - take a random CSV with headers, create a table and populate it with the CSV contents

imreFitos / csvtopostgresql Public

Notifications You must be signed in to change notification settings
Fork 1
Star 2

Import CSV To Postgresql table - take a random CSV with headers, create a table and populate it with the CSV contents

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 8 Commits
.gitignore		.gitignore
LICENSE		LICENSE
README		README
csvtopostgresql.rb		csvtopostgresql.rb
savetime.rb		savetime.rb

Repository files navigation

Ruby script to convert a CSV textfile with headers into Postgresql table. 

csvtopostgresql drops the existing table, creates a table based on the headers and populates the table with the contents.

usage: script path/to/file name-of-table

The script depends on the DATABASE_URL environmental variable to find the right database.

imre Fitos