Class NpgsqlDatabaseInfo
Base class for implementations which provide information about PostgreSQL and PostgreSQL-like databases (e.g. type definitions, capabilities...).
Inheritance
Inherited Members
Namespace: Npgsql
Assembly: Npgsql.dll
Syntax
public abstract class NpgsqlDatabaseInfo
Properties
HasIntegerDateTimes
Reports whether the backend uses the newer integer timestamp representation.
Declaration
public virtual bool HasIntegerDateTimes { get; protected set; }
Property Value
Type | Description |
---|---|
System.Boolean |
Host
The hostname of IP address of the database.
Declaration
public string Host { get; protected set; }
Property Value
Type | Description |
---|---|
System.String |
Name
The database name.
Declaration
public string Name { get; protected set; }
Property Value
Type | Description |
---|---|
System.String |
Port
The TCP port of the database.
Declaration
public int Port { get; protected set; }
Property Value
Type | Description |
---|---|
System.Int32 |
SupportsAdvisoryLocks
Whether the backend supports advisory locks.
Declaration
public virtual bool SupportsAdvisoryLocks { get; }
Property Value
Type | Description |
---|---|
System.Boolean |
SupportsCloseAll
Whether the backend supports the CLOSE ALL statement.
Declaration
public virtual bool SupportsCloseAll { get; }
Property Value
Type | Description |
---|---|
System.Boolean |
SupportsDiscard
Whether the backend supports the DISCARD statement.
Declaration
public virtual bool SupportsDiscard { get; }
Property Value
Type | Description |
---|---|
System.Boolean |
SupportsDiscardSequences
Whether the backend supports the DISCARD SEQUENCES statement.
Declaration
public virtual bool SupportsDiscardSequences { get; }
Property Value
Type | Description |
---|---|
System.Boolean |
SupportsDiscardTemp
Whether the backend supports the DISCARD TEMP statement.
Declaration
public virtual bool SupportsDiscardTemp { get; }
Property Value
Type | Description |
---|---|
System.Boolean |
SupportsEnumTypes
Whether the backend supports enum types.
Declaration
public virtual bool SupportsEnumTypes { get; }
Property Value
Type | Description |
---|---|
System.Boolean |
SupportsRangeTypes
Whether the backend supports range types.
Declaration
public virtual bool SupportsRangeTypes { get; }
Property Value
Type | Description |
---|---|
System.Boolean |
SupportsTransactions
Whether the database supports transactions.
Declaration
public virtual bool SupportsTransactions { get; protected set; }
Property Value
Type | Description |
---|---|
System.Boolean |
SupportsUnlisten
Whether the backend supports the UNLISTEN statement.
Declaration
public virtual bool SupportsUnlisten { get; }
Property Value
Type | Description |
---|---|
System.Boolean |
Version
The version of the PostgreSQL database we're connected to, as reported in the "server_version" parameter. Exposed via PostgreSqlVersion.
Declaration
public Version Version { get; protected set; }
Property Value
Type | Description |
---|---|
System.Version |
Methods
GetTypes()
Provides all PostgreSQL types detected in this database.
Declaration
protected abstract IEnumerable<PostgresType> GetTypes()
Returns
Type | Description |
---|---|
System.Collections.Generic.IEnumerable<PostgresType> |
ParseServerVersion(String)
Parses a PostgreSQL server version (e.g. 10.1, 9.6.3) and returns a CLR Version.
Declaration
protected static Version ParseServerVersion(string value)
Parameters
Type | Name | Description |
---|---|---|
System.String | value |
Returns
Type | Description |
---|---|
System.Version |
RegisterFactory(INpgsqlDatabaseInfoFactory)
Registers a new database info factory, which is used to load information about databases.
Declaration
public static void RegisterFactory(INpgsqlDatabaseInfoFactory factory)
Parameters
Type | Name | Description |
---|---|---|
INpgsqlDatabaseInfoFactory | factory |