Обсуждение: Sqlite to postgres database conversion.swedish chararacter issue
Hi,<br />I am new to postgre sql.I need to convert sqlite datbase to postgres database.i have nearly 15 table in my sqlitedatabase in which 3 table has swedish characters.<br /><br />I have used ogr2ogr to convert sqlite database to postgres.Iwas able to convert all the tables except the table which had the swedish character.I have used utf-8 encoding.<br/><br />I am searching for a sql insert which i can use to convert the table which has swedish character.<br/><br />any help regarding this would be appriciated.<br /><br />Thanks,<br />Sara<br /><br /><br />
i have never used ogr2ogr or done such thing but you migh try to export from sqlite by dumping or selecting data to CSV format (.separator command) and then make conversions using tr command ih shell for conversion of unwanted characters, or to use iconv for conversion to another encoding.
after convert is done you can insert it.
On Tue, Jun 14, 2011 at 7:37 PM, sara vanan <saravananlatitude@gmail.com> wrote:
Hi,
I am new to postgre sql.I need to convert sqlite datbase to postgres database.i have nearly 15 table in my sqlite database in which 3 table has swedish characters.
I have used ogr2ogr to convert sqlite database to postgres.I was able to convert all the tables except the table which had the swedish character.I have used utf-8 encoding.
I am searching for a sql insert which i can use to convert the table which has swedish character.
any help regarding this would be appriciated.
Thanks,
Sara
--
---------------------------------------
Viktor Bojović
---------------------------------------
Wherever I go, Murphy goes with me