copy help

From: val(at)webtribe(dot)net
To: pgsql-sql(at)postgresql(dot)org
Subject: copy help
Date: 2003-03-03 09:16:00
Message-ID: 20030303091602.475E818332@cheetah.webtribe.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I am trying to copy out about 50G of data.

When I used copy table X to '/opt/x.csv' using delimiters ','
with null as '';
and x.csv reached a size of 2G, I got the error message that the
file was too big.

How can I get around this without moving things out in smaller
packages (more time-consuming)?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Christoph Haller 2003-03-03 09:58:34 Re: Users and groups
Previous Message Victor Yegorov 2003-03-03 07:27:13 Re: Dynamic SELECT condition