| From: | Zeugswetter Andreas IZ5 <Andreas(dot)Zeugswetter(at)telecom(dot)at> |
|---|---|
| To: | "'tim(at)phpbuilder(dot)com'" <tim(at)phpbuilder(dot)com> |
| Cc: | "'pgsql-hackers(at)hub(dot)org'" <pgsql-hackers(at)hub(dot)org> |
| Subject: | AW: [HACKERS] "CANNOT EXTEND" - |
| Date: | 1999-03-18 17:56:39 |
| Message-ID: | 219F68D65015D011A8E000006F8590C60267B325@sdexcsrv1.f000.d0188.sd.spardat.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Terry Mackintosh | 1999-03-18 18:14:36 | Re: [ADMIN] delete data |
| Previous Message | Vadim Mikheev | 1999-03-18 17:47:34 | Re: [HACKERS] Re: [BUGS] General Bug Report: Bug in optimizer |