| From: | <kaiq(at)realtyideas(dot)com> |
|---|---|
| To: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | pg_dump of int8 with "? |
| Date: | 2000-02-15 00:41:41 |
| Message-ID: | Pine.LNX.4.10.10002141826540.31169-100000@picasso.realtyideas.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 !!!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2000-02-15 01:05:55 | Re: [GENERAL] Multi-Language Support and/or UTF-8 UNICODE |
| Previous Message | sheila bel | 2000-02-14 23:22:53 | Re: [GENERAL] converting MSAccess db tables into postgresql |