Skip to content

Instantly share code, notes, and snippets.

View eclubb's full-sized avatar

Earle Clubb eclubb

  • Valcom, Inc.
  • Roanoke, VA
View GitHub Profile
@eclubb
eclubb / sqlite2pg.sh
Created March 30, 2012 17:20
Script to import SQLite3 database into PostgreSQL
#!/bin/sh
# This script will migrate schema and data from a SQLite3 database to PostgreSQL.
# Schema translation based on http://stackoverflow.com/a/4581921/1303625.
# Some column types are not handled (e.g blobs).
SQLITE_DB_PATH=$1
PG_DB_NAME=$2
PG_USER_NAME=$3