postgresql-to-sqlite
postgresql-to-sqlite copied to clipboard
caiiiycuk
pg2sqlite is easy to use solution to create sqlite database from postgresql dump
I have a failure converting from this statement: ``` CREATE INDEX hydra_oauth2_flow_multi_query_idx ON hydra_oauth2_flow USING btree (((consent_error)::character varying(2)), state, subject, client_id, consent_skip, consent_remember, nid); ``` The output is ``` Create...
Hi, First, congrats for your work, pretty awesome repo! I have an issue regarding datetime columns. Within the PostgreSQL dump file, the datetime columns are defined as "timestamp with time...
`~/s/pg_to_sqlite_convert ❯❯❯ java -jar postgresql-to-sqlite/pg2sqlite.jar -d 54039.dump -o 54039.db 19:55:36.574 [main] WARN c.github.caiiiycuk.pg2sqlite.Config$ - You should set SQLITE_TMPDIR environment variable to control where sqlite stores temp files 19:55:36.612 [main] INFO...
The conversion seemingly succeeds but then the generated file is just 0 bytes. ``` 14:00:51.719 [main] INFO c.g.c.pg2sqlite.LoggedIterator - Progress 97.6%, elapsed: 0m 0s 252ms / remaining: 0m 0s 5ms......
Hello, I saw your answer in issue https://github.com/caiiiycuk/postgresql-to-sqlite/issues/12 I would like to know if it would be possible to add a type mapping function in order to end up with...
I’ve tried using the `-t text` which according to the notes uses the `ISO 8601` format. However the db I am attempting to migrate uses the following format for date/time....
