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
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:
Every day I discover Postgresql's new features. Today : make women happy :)
2015-03-25 4:27 GMT+01:00 dpop...@uvic.ca:
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
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.
Thank
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
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
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