Pages

Tuesday, November 19, 2019

using pspg for SQLite

pspg can be used for SQLite too. Not directly, because sqlite client is not too rich. But there are some possibilities:

a) you can use litecli. litecli is able to use pspg

b) generate CSV from sqlite client - this format is well readable for pspg

sqlite3 -csv -header testdb.db 'select * from foo2' | pspg --csv --csv-header=on --double-header

Thank you for tip to Trent W. Buck.

No comments:

Post a Comment