I appreciate all the information Thank you, ray
-----Original Message----- From: Dimitri Fontaine [mailto:[email protected]] Sent: Sunday, March 06, 2011 3:19 PM To: ray Cc: [email protected] Subject: Re: [GENERAL] How to Create Table from CSV ray <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
