Re: [SQL] query expression body ::= joined table grammar rule not accepted by Postgres

2011-06-16 Thread Tom Lane
Clem Dickey dicke...@us.ibm.com 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. The later versions of the spec don't seem to permit joined table to be

[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

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