*** stliu has joined #ingres | 04:26 | |
*** cytrinox_ has joined #ingres | 05:19 | |
*** cytrinox has quit IRC | 05:22 | |
*** cytrinox_ is now known as cytrinox | 05:22 | |
*** Alex| has joined #ingres | 06:32 | |
*** ChanServ sets mode: +o Alex| | 06:32 | |
*** Mud has joined #ingres | 06:52 | |
*** Mud is now known as Guest61848 | 06:52 | |
*** Alex| has quit IRC | 07:05 | |
*** Guest61848 has quit IRC | 07:17 | |
*** Guest61848 has joined #ingres | 07:22 | |
*** Alex| has joined #ingres | 07:23 | |
*** ChanServ sets mode: +o Alex| | 07:23 | |
Dejan | morning | 08:07 |
---|---|---|
*** Dejan has quit IRC | 08:22 | |
*** KermitTheFragger has joined #ingres | 09:16 | |
*** Dejan has joined #ingres | 09:28 | |
*** Dejan has quit IRC | 10:52 | |
*** stliu has quit IRC | 11:10 | |
*** Guest61848 has quit IRC | 11:17 | |
*** Mud has joined #ingres | 11:22 | |
*** Mud is now known as Guest56595 | 11:23 | |
pboro | argh | 13:27 |
pboro | how in the hell do I COPY TABLE without ingres adding padding to the column values | 13:27 |
Vroomfondle | use a format which begins with 'c0'? | 13:29 |
Vroomfondle | c0nl, c0comma etc | 13:29 |
Vroomfondle | fairly sure that doesn't add padding | 13:29 |
pboro | I'll try that, thanks | 13:29 |
pboro | hmmh... I guess c0 is short for char(0)? | 13:31 |
pboro | "Stored as fixed-length strings (padded with blanks if necessary). For character data, the length of the string written to the file is the same as the column length." | 13:31 |
Vroomfondle | ah, hrm | 13:31 |
Vroomfondle | I think it is short for that, yes | 13:32 |
pboro | I'll go have a lunch and return to ponder this later... maybe I'll just do foo || '%' || bar || '%' || ... in CREATE TABLE tmp AS and then copy that | 13:32 |
pboro | or something. :D -> | 13:32 |
Vroomfondle | personally I'd just do the COPY TABLE and then mung the file in a script, but yeah... that way might work too ;) | 13:33 |
*** Guest56595 has quit IRC | 15:17 | |
*** Mud has joined #ingres | 15:22 | |
*** Mud is now known as Guest48173 | 15:23 | |
*** Alex| has quit IRC | 15:44 | |
*** Alex| has joined #ingres | 16:21 | |
*** ChanServ sets mode: +o Alex| | 16:21 | |
*** DerMeister has joined #ingres | 17:43 | |
*** Guest48173 has quit IRC | 17:58 | |
*** Mud has joined #ingres | 18:00 | |
*** Mud is now known as Guest74671 | 18:00 | |
*** Alex| has quit IRC | 18:16 | |
*** KermitTheFragger has quit IRC | 18:40 | |
*** Guest74671 has quit IRC | 19:17 | |
*** Mud has joined #ingres | 19:21 | |
*** DerMeister has quit IRC | 22:11 | |
*** Mud has quit IRC | 23:04 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!