Columns not auto populating when importing CSV data on PgAdmin for PostgreSQL (On Windows)
I am on Windows. I created a database, went to the schemas tab on the database dropdown, and created a table. I entered in all of the info for the table. However, when I import a CSV file to the table, the columns of the table do not show up on the column tab. As a result, I cannot import the csv data. It will not even allow me enter in the column names myself.
This is the co开发者_运维知识库de I used to create a table:
CREATE TABLE table_name(column1 int, column2 varchar, column3 varchar, column4 int);
select * from table_name
After, I clicked on the table I had made to import csv data. However, the columns will not autopopulate when I finished importing the csv data with a header, and UTF-8 encoding.
I reinstalled PgAdmin but it did not solve anything. I cannot enter in the column names myself as well. The column names of the table should be autogenerating but it is not working.
精彩评论