I appreciate all the information
Thank you,
ray
-Original Message-
From: Dimitri Fontaine [mailto:dimi...@2ndquadrant.fr]
Sent: Sunday, March 06, 2011 3:19 PM
To: ray
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to Create Table from CSV
ray writes:
> I would like
ray writes:
> I would like to create a table from a CSV file (the first line is
> headers which I want to use as column names) saved from Excel. I have
You have to manually create the table and its columns, as other said.
The tricky part that is hard (or impossible) to automate is deciding
which
On Sun, 6 Mar 2011, ray wrote:
I would like to create a table from a CSV file (the first line is
headers which I want to use as column names) saved from Excel. I have
a new database which I have been able to create tables from a
tutorial. But I haven?t been able to produce this new table. The
On Mar 7, 2011, at 12:13 AM, ray wrote:
>
> CREATE TABLE Equpment_List_Sheet2 FROM 'Equipment List, reference
> r1_Sheet2.csv' WITH DELIMITER ',' NULL '' CSV HEADER;
> ERROR: syntax error at or near "FROM"
> LINE 1: CREATE TABLE Equpment_List_Sheet2 FROM 'Equipment List,
> refe...
>
> ^
>
I would like to create a table from a CSV file (the first line is
headers which I want to use as column names) saved from Excel. I have
a new database which I have been able to create tables from a
tutorial. But I haven’t been able to produce this new table. The
following are my attempts:
CREAT
