使用C#和NPGSQL将数据从csv文件导入到postgresql表中

using System;
using System.IO;
using Npgsql;

public void ImportDataFromCSV(string csvFilePath, string connectionString, string tableName)
{
    using (var connection = new NpgsqlConnection(connectionString))
    {
        connection.Open();

        using (var command = new NpgsqlCommand())
        {
            command.Connection = connection;

            // 创建目标表
            command.CommandText = $"CREATE TABLE IF NOT EXISTS {tableName} (column1 datatype1, column2 datatype2, ...)";
            command.ExecuteNonQuery();

            // 读取CSV文件
            using (var reader = new StreamReader(csvFilePath))
            {
                while (!reader.EndOfStream)
                {
                    var line = reader.ReadLine();
                    var values = line.Split(',');

                    // 插入数据到表中
                    command.CommandText = $"INSERT INTO {tableName} VALUES (@value1, @value2, ...)";
                    command.Parameters.AddWithValue("@value1", values[0]);
                    command.Parameters.AddWithValue("@value2", values[1]);
                    // 添加更多参数以匹配CSV文件中的列数

                    command.ExecuteNonQuery();
                    command.Parameters.Clear();
                }
            }
        }

        connection.Close();
    }
}

string csvFilePath = "path/to/your/csv/file.csv";
string connectionString = "your_connection_string";
string tableName = "your_table_name";

ImportDataFromCSV(csvFilePath, connectionString, tableName);