I want SQLite database file open in PostgreSQL. Please give to me Answer,Before We are Useing Sqlite Database Now We are Moveing into PostgreSql Database
Asked
Active
Viewed 3,705 times
4
-
1Possible duplicate of [Convert SQLITE SQL dump file to POSTGRESQL](https://stackoverflow.com/questions/4581727/convert-sqlite-sql-dump-file-to-postgresql) – Klaus Gütter Jan 05 '19 at 07:42
-
1PostgreSQL has [Foreign Data Wrappers](https://wiki.postgresql.org/wiki/Foreign_data_wrappers) which can directly connect to a SQLite database – Raymond Nijland Jan 05 '19 at 16:10
-
If you are moving to a PostgreSQL then better to do it through db dump as duplicate instructs. If there is too much manual job altering the dump maybe creating the dump with help of foreign data adapter for SQLite is a better solution. – pirho Jan 05 '19 at 17:50