Npgsql从数据库读取特殊字符

using Npgsql;

// 创建数据库连接
var connectionString = "Host=myserver;Username=myuser;Password=mypassword;Database=mydatabase";
using var connection = new NpgsqlConnection(connectionString);
connection.Open();

// 从数据库中读取特殊字符
var commandText = "SELECT * FROM mytable WHERE column = @value";
using var command = new NpgsqlCommand(commandText, connection);
command.Parameters.AddWithValue("value", "special'characters");

using var reader = command.ExecuteReader();
while (reader.Read())
{
    // 处理查询结果
    var result = reader.GetString(0);
    Console.WriteLine(result);
}