Convert PostgreSQL data to SQLite

psql2sqlite.sed

#! /bin/sed -f

# add begin transaction
1s/^SET .*$/END;\nBEGIN;\n/
1s/^-- .*$/END;\nBEGIN;\n/
1s/^/BEGIN;\n/

# remove configuration settings
/^SET /d

# remove comments
/^--/d

# remove sequence values
/^SELECT pg_catalog.setval/d

# add end transaction
$s/$/\nEND;\n/