Show / Hide Table of Contents

Class NpgsqlDatabaseInfo

Base class for implementations which provide information about PostgreSQL and PostgreSQL-like databases (e.g. type definitions, capabilities...).

Inheritance
System.Object
NpgsqlDatabaseInfo
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Npgsql
Assembly: Npgsql.dll
Syntax
public abstract class NpgsqlDatabaseInfo

Constructors

NpgsqlDatabaseInfo(String, Int32, String, Version)

Initializes the instance of NpgsqlDatabaseInfo.

Declaration
protected NpgsqlDatabaseInfo(string host, int port, string databaseName, Version version)
Parameters
Type Name Description
System.String host
System.Int32 port
System.String databaseName
System.Version version

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; }
Property Value
Type Description
System.String

Name

The database name.

Declaration
public string Name { get; }
Property Value
Type Description
System.String

Port

The TCP port of the database.

Declaration
public int Port { get; }
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; }
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
In This Article
Back to top Generated by DocFX