> 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