ogr2ogr -F SQLITE YOURDB.sqlite PG:"host=HOSTNAMEORIP port=XXXX dbname=YOURDB user=YOURUSER password=YOURPASSWORD" -sql "select * from YOURTABLE" -dsco SPATIALITE=YES