Class PostgresType
Represents a PostgreSQL data type, such as int4 or text, as discovered from pg_type. This class is abstract, see derived classes for concrete types of PostgreSQL types.
Inheritance
Namespace: Npgsql.PostgresTypes
Assembly: Npgsql.dll
Syntax
public abstract class PostgresType
Remarks
Instances of this class are shared between connections to the same databases. For more info about what this class and its subclasses represent, see https://www.postgresql.org/docs/current/static/catalog-pg-type.html.
Properties
| Improve this Doc View SourceArray
If a PostgreSQL array type exists for this type, it will be referenced here. Otherwise null.
Declaration
public PostgresArrayType? Array { get; }
Property Value
Type | Description |
---|---|
PostgresArrayType |
Remarks
Instances of this class are shared between connections to the same databases. For more info about what this class and its subclasses represent, see https://www.postgresql.org/docs/current/static/catalog-pg-type.html.
DisplayName
A display name for this backend type, including the namespace unless it is pg_catalog (the namespace for all built-in types).
Declaration
public string DisplayName { get; }
Property Value
Type | Description |
---|---|
string |
Remarks
Instances of this class are shared between connections to the same databases. For more info about what this class and its subclasses represent, see https://www.postgresql.org/docs/current/static/catalog-pg-type.html.
FullName
The full name of the backend type, including its namespace.
Declaration
public string FullName { get; }
Property Value
Type | Description |
---|---|
string |
Remarks
Instances of this class are shared between connections to the same databases. For more info about what this class and its subclasses represent, see https://www.postgresql.org/docs/current/static/catalog-pg-type.html.
InternalName
The data type's internal PostgreSQL name (e.g. _int4
not integer[]
).
See Name for a more user-friendly name.
Declaration
public string InternalName { get; }
Property Value
Type | Description |
---|---|
string |
Remarks
Instances of this class are shared between connections to the same databases. For more info about what this class and its subclasses represent, see https://www.postgresql.org/docs/current/static/catalog-pg-type.html.
Name
The data type's name.
Declaration
public string Name { get; }
Property Value
Type | Description |
---|---|
string |
Remarks
Note that this is the standard, user-displayable type name (e.g. integer[]) rather than the internal PostgreSQL name as it is in pg_type (_int4). See InternalName for the latter.
Namespace
The data type's namespace (or schema).
Declaration
public string Namespace { get; }
Property Value
Type | Description |
---|---|
string |
Remarks
Instances of this class are shared between connections to the same databases. For more info about what this class and its subclasses represent, see https://www.postgresql.org/docs/current/static/catalog-pg-type.html.
OID
The data type's OID - a unique id identifying the data type in a given database (in pg_type).
Declaration
public uint OID { get; }
Property Value
Type | Description |
---|---|
uint |
Remarks
Instances of this class are shared between connections to the same databases. For more info about what this class and its subclasses represent, see https://www.postgresql.org/docs/current/static/catalog-pg-type.html.
Range
If a PostgreSQL range type exists for this type, it will be referenced here. Otherwise null.
Declaration
public PostgresRangeType? Range { get; }
Property Value
Type | Description |
---|---|
PostgresRangeType |
Remarks
Instances of this class are shared between connections to the same databases. For more info about what this class and its subclasses represent, see https://www.postgresql.org/docs/current/static/catalog-pg-type.html.
Methods
| Improve this Doc View SourceToString()
Returns a string that represents the current object.
Declaration
public override string ToString()
Returns
Type | Description |
---|---|
string |
Remarks
Instances of this class are shared between connections to the same databases. For more info about what this class and its subclasses represent, see https://www.postgresql.org/docs/current/static/catalog-pg-type.html.