
> copy tbl_name to 'file';
> 
> Have any ideas for splitting that?
> 
> 
I was going to answer with the following:

#!/bin/sh
mkfifo tapepipe.$$
( gzip --fast -c < tapepipe.$$ | split -b512m - tbl_name.unl. ) &
psql -c "copy tbl_name to 'tapepipe.$$'" regression 
rm tapepipe.$$

but it does not work, since psql does not like the named pipe. So use:

psql -qc 'copy onek to stdout' regression | gzip --fast -c | split -b512m -
onek.unl.

Andreas

Thu, 18 Mar 1999 18:56:39 +0100
Zeugswetter Andreas IZ5 <Andreas.Zeugswetter@telecom.at>
AW: [HACKERS] "CANNOT EXTEND" -