Table of Contents

Class NpgsqlDbColumn

Namespace
Npgsql.Schema
Assembly
Npgsql.dll

Provides schema information about a column.

public class NpgsqlDbColumn : DbColumn
Inheritance
NpgsqlDbColumn
Inherited Members

Remarks

Note that this can correspond to a field returned in a query which isn't an actual table column

See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.

Constructors

NpgsqlDbColumn()

Initializes a new instance of the NpgsqlDbColumn class.

public NpgsqlDbColumn()

Properties

AllowDBNull

public bool? AllowDBNull { get; protected set; }

Property Value

bool?

BaseCatalogName

public string BaseCatalogName { get; protected set; }

Property Value

string

BaseColumnName

public string? BaseColumnName { get; protected set; }

Property Value

string

BaseSchemaName

public string? BaseSchemaName { get; protected set; }

Property Value

string

BaseServerName

public string BaseServerName { get; protected set; }

Property Value

string

BaseTableName

public string? BaseTableName { get; protected set; }

Property Value

string

ColumnAttributeNumber

The column's position within its table. Note that this is different from ColumnOrdinal, which is the column's position within the resultset.

public short? ColumnAttributeNumber { get; }

Property Value

short?

ColumnName

public string ColumnName { get; protected set; }

Property Value

string

ColumnOrdinal

public int? ColumnOrdinal { get; protected set; }

Property Value

int?

ColumnSize

public int? ColumnSize { get; protected set; }

Property Value

int?

DataType

public Type? DataType { get; protected set; }

Property Value

Type

DataTypeName

public string DataTypeName { get; protected set; }

Property Value

string

DefaultValue

The default SQL expression for this column.

public string? DefaultValue { get; }

Property Value

string

IsAliased

public bool? IsAliased { get; protected set; }

Property Value

bool?

IsAutoIncrement

public bool? IsAutoIncrement { get; protected set; }

Property Value

bool?

IsIdentity

public bool? IsIdentity { get; protected set; }

Property Value

bool?

IsKey

public bool? IsKey { get; protected set; }

Property Value

bool?

IsLong

public bool? IsLong { get; protected set; }

Property Value

bool?

IsReadOnly

public bool? IsReadOnly { get; protected set; }

Property Value

bool?

IsUnique

public bool? IsUnique { get; protected set; }

Property Value

bool?

this[string]

public override object? this[string propertyName] { get; }

Parameters

propertyName string

Property Value

object

NpgsqlDbType

The NpgsqlDbType value for this column's type.

public NpgsqlDbType? NpgsqlDbType { get; }

Property Value

NpgsqlDbType?

NumericPrecision

public int? NumericPrecision { get; protected set; }

Property Value

int?

NumericScale

public int? NumericScale { get; protected set; }

Property Value

int?

PostgresType

The PostgresType describing the type of this column.

public PostgresType PostgresType { get; }

Property Value

PostgresType

TableOID

The OID of the PostgreSQL table of this column.

public uint TableOID { get; }

Property Value

uint

TypeOID

The OID of the type of this column in the PostgreSQL pg_type catalog table.

public uint TypeOID { get; }

Property Value

uint

UdtAssemblyQualifiedName

public string? UdtAssemblyQualifiedName { get; protected set; }

Property Value

string