当前位置: 动力学知识库 > 问答 > 编程问答 >

Retrieving particular data from postgresql and storing them in sqlite android

问题描述:

I am having a postgresql database which contains 10 tables with multiple records in each table.I retrieve particular information using select query.

What i want

I want only those selected results to be stored in my android sqlite database.I did convert the postgresql database to sqlite database using a tool named SQLiteConverter version 1.9.5,but it copies not only the structure of the tables but also all the records of each and every table.However i want only some selected result of the postgresql database to be stored in sqlite database.Is there any tool available which can store only some data but complete structure of postgresql into sqlite?

P.S:I searched for this issue but no other posts could make me clear in achieving this.

EDIT

Now i can always create tables in sqlite programmatically/manually with similar structure to that of the tables in my postgresql.Then i can retrieve data from postgresql and insert them into sqlite.But i wanted to do it using Any tool if available.

分享给朋友:
您可能感兴趣的文章:
随机阅读: