Scott Marlowe wrote:
On Dec 17, 2007 2:06 PM, A.Burbello <burbello3000@xxxxxxxxxxxx> wrote:
I consider this way a good practice to transport the
files. This is because I have table that has more than
30GB.
But if the OS was windows, couldn't split the files
because postgres doesn't has this feature!
Could be a good option if postgres had native.
Weel, I will try this:
eg: $ pg_dump postgres -U postgres -f split.txt |
split --bytes=10m
http://gnuwin32.sourceforge.net/packages/coreutils.htm
for now. I used these back in the day (NT4.0 SP4 or so) and they
worked a charm back then. Heck, even ln worked ( in a manner of
speaking ) back then.
There's also Uwin from AT&T:
http://www.research.att.com/sw/tools/uwin
list of available commands and man pages:
http://www.research.att.com/~gsf/man/man1/
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
