[GENERAL] pg_dump of int8 with "?
От | kaiq@realtyideas.com |
---|---|
Тема | [GENERAL] pg_dump of int8 with "? |
Дата | |
Msg-id | Pine.LNX.4.10.10002141826540.31169-100000@picasso.realtyideas.com обсуждение исходный текст |
Ответ на | Multi-Language Support and/or UTF-8 UNICODE (RK Street <R.K.Street@rl.ac.uk>) |
Ответы |
like '%6' does not match '%66'?
|
Список | pgsql-general |
I'm using pg_dump as a data transfer tool to input data to m$sql. why I can not use copy and then m$sql's bcp? because m$sql strangly ignore the difference between null and empty string (in bcp's input format, no quotation mark used, just like pg. however, it has no escape for null.). so, I used pg_dump (ya, it is slow, but the db is not that large, only about 20M). everything goes smooth, untill i hit a table with int8: m$sql complains invalid implicit type convertion. I checked. the damn thing is right this time. PG is not consistant: for int8, it uses quotation mark, treat it as string! I understand this perhaps is a techique to handle the long integer. And, pg_dump never meant to be used as I used. So, no complain here :-). just ask if there is a way to do it right? or if you also (like me) have to bear the shame of using m$sql, please tell me how can handle this right? -- if no other way, I will simply ignore the diff between null and empty string. -- it's in M$ world, ha. thanks in advance !!! ************
В списке pgsql-general по дате отправления: