You can use builtin COPY <https://www.postgresql.org/docs/10/static/sql-copy.html> tool to load the CSV data into the table but the destination table must be present before you load CSV. COPY your_table(column_1, column_2, column_3...column_N) FROM 'C:\tmp\mydata.csv' DELIMITER ',' CSV HEADER;
If you wish then you can try third party tool called pgfutter <https://github.com/lukasmartinelli/pgfutter>. -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company On Wed, Feb 7, 2018 at 8:18 PM, TedJones <t...@mentra.co.uk> wrote: > I am quite new to PostgreSQL and I am having difficulty with the following: > > I am trying to input a csv file into a table that has a very large number > of > columns. This means that it is impractical to create a table and specify > the > name of all the columns. Can the column headings be taken from the first > line of the csv file? > > Additionally, I have tried to do this with smaller number of columns with > CREATE table but the column headings appear in a different order to what is > in the csv file (that cannot be edited). I then cannot edit (cut and paste > as you would expect!) the SQL to change the order of the columns. Surely > there must be a way of doing this!! I have no control over the input csv > files that contain the data. > > > > -- > Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin- > support-f2191615.html > >
