[SQL] Sqlite to postgres database conversion.swedish chararacter issue
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
Re: [SQL] Sqlite to postgres database conversion.swedish chararacter issue
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 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
Re: [SQL] " ::= " grammar rule not accepted by Postgres
On 06/15/2011 10:59 PM, Tom Lane wrote: Clem Dickey writes: This expression is (I think) a well-formed query, but is rejected by Postgresql 8.4 (t is a table name). t t1 NATURAL JOIN t t2; Hmm ... I think you are looking at SQL92 or SQL99. [ digs a bit more... ] Ah, here we are: Annex E of SQL:2003 calls out various incompatibilities from SQL:99, notably 6) In ISO/IEC 9075-2:1999, a,, or could consist of a. None of those three elements can consist of a in this edition of ISO/IEC 9075. Thanks for the research. I was indeed reading from SQL99, which was current the last time I used SQL. I'll have to spring for a newer standard (or the equivalent). -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
