使用C#将文本文件数据导入PostgreSQL数据库

using Npgsql;

string connString = "Host=your_host;Port=your_port;Database=your_database;Username=your_username;Password=your_password";

List<string> data = new List<string>();

using (StreamReader reader = new StreamReader("path_to_text_file"))
{
    string line;
    while ((line = reader.ReadLine()) != null)
    {
        data.Add(line);
    }
}

using (NpgsqlConnection conn = new NpgsqlConnection(connString))
{
    conn.Open();

    // 执行插入数据的操作
}

using (NpgsqlCommand cmd = new NpgsqlCommand())
{
    cmd.Connection = conn;

    foreach (string line in data)
    {
        cmd.CommandText = $"INSERT INTO your_table_name (column1, column2, ...) VALUES ({line})";
        cmd.ExecuteNonQuery();
    }
}

conn.Close();