| From: | 김대호 <daiho1(dot)kim(at)samsung(dot)com> |
|---|---|
| To: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | 손우성 <woosung(dot)sohn(at)samsung(dot)com> |
| Subject: | Add limit option to copy function |
| Date: | 2020-01-20 05:11:05 |
| Message-ID: | 488189700.1044540.1579497065808@mail-kr3-3 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Dear all.
I suggest adding a limit option to the copy function that limits count of input/output.
I think this will be useful for testing with sample data.
Usage is similar to SELECT LIMIT.
COPY TO : COPY (Table) TO '(File)' CSV LIMIT (count);
COPY FROM : COPY (Table) FROM '(File)' BINARY LIMIT (count);
| Attachment | Content-Type | Size |
|---|---|---|
| copy-limit-feature.patch | application/octet-stream | 2.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2020-01-20 05:22:38 | Re: Master Master replication |
| Previous Message | Pavel Stehule | 2020-01-20 04:49:38 | Re: range_agg |