public void ColumnSize()
{
using (var conn = OpenConnection())
{
conn.ExecuteNonQuery("CREATE TEMP TABLE data (bounded VARCHAR(30), unbounded VARCHAR)");
using (var cmd = new NpgsqlCommand("SELECT bounded,unbounded,'a'::VARCHAR(10),'b'::VARCHAR FROM data", conn))
using (var reader = cmd.ExecuteReader(CommandBehavior.SchemaOnly))
{
var columns = reader.GetColumnSchema();
Assert.That(columns[0].ColumnSize, Is.EqualTo(30));
Assert.That(columns[1].ColumnSize, Is.Null);
Assert.That(columns[2].ColumnSize, Is.EqualTo(10));
Assert.That(columns[3].ColumnSize, Is.Null);
}
}
}