postgresql import data to database by columns

Question

I am new to postgresql and I am trying to import my csv data into the database I created. I created a table in my database with a few columns. I would like to import my data to the table while filtering the columns to the ones I created in the database.

An example of my data source:

X	Y	Z
One	Two	Three

For example, my columns in the table created: X and Z, so I would like only to import X and Z. I hope I am being clear and sorry for any inconveniences. Thanks

Josh · Accepted Answer · 2021-06-23 08:55:50Z

1

You can create a temporary table with all the columns from csv.

Then you can copy the file into the temporary table

copy temp_table (x, y, z) from 'csv_file_path'

After this you can insert into your table from the temporary table

insert into your_table (x, z) select x, z from temp_table

answered Jun 23, 2021 at 8:55

Josh

693 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Yacer Saoud Over a year ago

should I write this in public's script or my table's script ? thank you for the answer too!

Josh Over a year ago

what do mean by public's script or table's script?

Collectives™ on Stack Overflow

postgresql import data to database by columns

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related