Re: [GENERAL] Load Data with COPY

2015-03-24 Thread Nicolas Paris
Every day I discover Postgresql's new features. Today : make women happy :) 2015-03-25 4:27 GMT+01:00 : > Successfully loaded two files into two different tables. Happy. :-) > > Diana > > > Yes, it is a header in the .csv file. I did not know that there is such > an > > option as specifying WITH

Re: [GENERAL] Load Data with COPY

2015-03-24 Thread dpopova
Successfully loaded two files into two different tables. Happy. :-) Diana > Yes, it is a header in the .csv file. I did not know that there is such an > option as specifying WITH HEADER in COPY. > I should have tried to delete the header and specify the loading columns > in the COPY itself. > > T

Re: [GENERAL] Load Data with COPY

2015-03-24 Thread dpopova
Yes, it is a header in the .csv file. I did not know that there is such an option as specifying WITH HEADER in COPY. I should have tried to delete the header and specify the loading columns in the COPY itself. Thank you, Adrian, Ray, and John. Diana > On 03/24/2015 02:16 PM, Raymond O'Donnell w

Re: [GENERAL] Load Data with COPY

2015-03-24 Thread Adrian Klaver
On 03/24/2015 02:16 PM, Raymond O'Donnell wrote: On 24/03/2015 21:00, dpop...@uvic.ca wrote: I have 7,000+ rows of data in Numbers. Exported to .csv file, tried to load into postgres table with COPY FROM, failed. Postgres does not recognize the format: ERROR: invalid input syntax for integer:

Re: [GENERAL] Load Data with COPY

2015-03-24 Thread John R Pierce
On 3/24/2015 2:16 PM, Raymond O'Donnell wrote: Is there a header row in the CSV file? - if so, delete it and try again. or specify 'WITH HEADER' on the COPY command -- john, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

Re: [GENERAL] Load Data with COPY

2015-03-24 Thread Raymond O'Donnell
On 24/03/2015 21:00, dpop...@uvic.ca wrote: > I have 7,000+ rows of data in Numbers. Exported to .csv file, tried to > load into postgres table with COPY FROM, failed. Postgres does not > recognize the format: > > ERROR: invalid input syntax for integer: "project_name,... > > Is there any way to

[GENERAL] Load Data with COPY

2015-03-24 Thread dpopova
I have 7,000+ rows of data in Numbers. Exported to .csv file, tried to load into postgres table with COPY FROM, failed. Postgres does not recognize the format: ERROR: invalid input syntax for integer: "project_name,... Is there any way to export/convert the data in Numbers into a format recogniz