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
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
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: Ann
