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

actmd / csvtopostgresql Public

forked from imreFitos/csvtopostgresql

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

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

MIT license

0 stars 1 fork Branches Tags Activity

Star

Notifications

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 10 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