| From: | shweta(dot)bhandari(at)gmail(dot)com |
|---|---|
| To: | pgsql-docs(at)postgresql(dot)org |
| Subject: | Postgres copy command |
| Date: | 2016-12-16 14:37:49 |
| Message-ID: | 20161216143749.13338.34884@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.1/static/sql-copy.html
Description:
When exporting table data to csv boolean value true is written as 't' and
false as 'f'.
Also I am not able to add quotes to any of the values.
Following is the command I am using
COPY "OldModel"."Skills__c" TO
'D:\CopyOutCommandResults\Skill_Category__c.csv' DELIMITER ',' CSV HEADER
QUOTE '"'
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2016-12-16 16:28:49 | Re: Missing tablespace_option | effective_io_concurrency |
| Previous Message | James McLean | 2016-12-14 01:30:15 | Correction: Hashing speeds |