PostgreSqlDbSetting
A setting class used for the PostgreSql data provider.
This class is the BaseDbSetting-derived implementation for PostgreSQL. It is automatically registered by PostgreSqlBootstrap — you do not need to instantiate it directly under normal use.
Configured Values
| Property | Value |
|---|---|
| AreIndexNamesUniquePerSchema | true |
| AreTableHintsSupported | false |
| ClosingQuote | " |
| DefaultSchema | public |
| IsAffectedRowsSupported | true |
| IsDirectionSupported | true |
| IsExecuteReaderDisposable | true |
| IsMultiStatementExecutable | true |
| IsInsertAllBatchable | true |
| IsPreparable | true |
| IsSchemaSupported | true |
| IsTransactionSupported | true |
| IsUseUpsert | false |
| RequiresDbTypeBeforeValue | false |
| SkipsUnreferencedParameters | false |
| MaxParameterCount | 2098 |
| MultiStatementSeparator | ; |
| OpeningQuote | " |
| ParameterPrefix | @ |
| Provider | PostgreSql |
| SqlTextParameterPrefix | @ |
MultiStatementSeparatoris not set by this class explicitly — it is inherited unchanged from BaseDbSetting’s own default (;).
Usability
Use DbSettingMapper to override it with a custom implementation.
DbSettingMapper.Add(typeof(NpgsqlConnection), new MyCustomPostgreSqlDbSetting(), true);