Search Postgresql Archives

Re: How to Create Table from CSV

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



ray <ray@xxxxxxxxx> 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 data type to use for each column.

Once you've done that, actually importing the data is a matter of using
the COPY command or the pgloader tool.

In PostgreSQL 9.1 you will be able to use CREATE FOREIGN TABLE to
achieve that in one step, see:

  CREATE FOREIGN TABLE

  http://developer.postgresql.org/pgdocs/postgres/ddl-foreign-data.html
  http://developer.postgresql.org/pgdocs/postgres/sql-createforeigndatawrapper.html
  http://developer.postgresql.org/pgdocs/postgres/file-fdw.html

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux