Skip to content

Instantly share code, notes, and snippets.

@HGebhardt

HGebhardt/psql2sqlite.sed

Created April 28, 2015 12:49
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save HGebhardt/9908551640b5b16e7bed to your computer and use it in GitHub Desktop.
Save HGebhardt/9908551640b5b16e7bed to your computer and use it in GitHub Desktop.
Download ZIP
Convert PostgreSQL data to SQLite
Raw
psql2sqlite.sed
#! /bin/sed -f
# remove configuration settings
/^SET /d
# remove comments
/^--/d
# remove sequence values
/^SELECT pg_catalog.setval/d
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment