开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜