Re: [SQL] Sqlite to postgres database conversion.swedish chararacter issue

2011-06-16 Thread Viktor Bojović
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 c

[SQL] Sqlite to postgres database conversion.swedish chararacter issue

2011-06-16 Thread sara vanan
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 swe