Class PostgreSQLSqlBuilder

Namespace

LinqToDB.DataProvider.PostgreSQL

Assembly

linq2db.dll

public class PostgreSQLSqlBuilder : BasicSqlBuilder<PostgreSQLOptions>, ISqlBuilder

Inheritance

object

BasicSqlBuilder

BasicSqlBuilder<PostgreSQLOptions>

PostgreSQLSqlBuilder

Implements

ISqlBuilder

Derived

PostgreSQLSql15Builder

Inherited Members

BasicSqlBuilder<PostgreSQLOptions>.ProviderOptions

BasicSqlBuilder.DataProvider

BasicSqlBuilder.Statement

BasicSqlBuilder.Indent

BasicSqlBuilder.BuildStep

BasicSqlBuilder.SqlOptimizer

BasicSqlBuilder.SkipAlias

BasicSqlBuilder.EndLine

BasicSqlBuilder.BuildExpressionContext

BasicSqlBuilder.CanSkipRootAliases(SqlStatement)

BasicSqlBuilder.CommandCount(SqlStatement)

BasicSqlBuilder.RemoveInlineComma()

BasicSqlBuilder.ConvertElement<T>(T)

BasicSqlBuilder.BuildSql(int, SqlStatement, StringBuilder, OptimizationContext, int)

BasicSqlBuilder.BuildSetOperation(SetOperation, StringBuilder)

BasicSqlBuilder.BuildSql(int, SqlStatement, StringBuilder, OptimizationContext, int, bool)

BasicSqlBuilder.MergeSqlBuilderData(BasicSqlBuilder)

BasicSqlBuilder.BuildCommand(SqlStatement, int)

BasicSqlBuilder.FinalizeBuildQuery(SqlStatement)

BasicSqlBuilder.BuildSqlBuilder(SelectQuery, int, bool)

BasicSqlBuilder.WithStringBuilderBuildExpression(ISqlExpression)

BasicSqlBuilder.WithStringBuilderBuildExpression(int, ISqlExpression)

BasicSqlBuilder.WithStringBuilder<TContext>(Action<TContext>, TContext)

BasicSqlBuilder.ParenthesizeJoin(List<SqlJoinedTable>)

BasicSqlBuilder.BuildSqlForUnion()

BasicSqlBuilder.BuildDeleteQuery(SqlDeleteStatement)

BasicSqlBuilder.BuildDeleteQuery2(SqlDeleteStatement)

BasicSqlBuilder.BuildUpdateQuery(SqlStatement, SelectQuery, SqlUpdateClause)

BasicSqlBuilder.BuildSelectQuery(SqlSelectStatement)

BasicSqlBuilder.BuildCteBody(SelectQuery)

BasicSqlBuilder.BuildInsertQuery(SqlStatement, SqlInsertClause, bool)

BasicSqlBuilder.BuildInsertQuery2(SqlStatement, SqlInsertClause, bool)

BasicSqlBuilder.BuildMultiInsertQuery(SqlMultiInsertStatement)

BasicSqlBuilder.BuildUnknownQuery()

BasicSqlBuilder.BuildObjectNameSuffix(StringBuilder, SqlObjectName, bool)

BasicSqlBuilder.ConvertInline(string, ConvertType)

BasicSqlBuilder.BuildWithClause(SqlWithClause)

BasicSqlBuilder.BuildSelectClause(SelectQuery)

BasicSqlBuilder.StartStatementQueryExtensions(SelectQuery)

BasicSqlBuilder.GetSelectedColumns(SelectQuery)

BasicSqlBuilder.BuildColumns(SelectQuery)

BasicSqlBuilder.BuildOutputColumnExpressions(IReadOnlyList<ISqlExpression>)

BasicSqlBuilder.WrapBooleanExpression(ISqlExpression)

BasicSqlBuilder.BuildColumnExpression(SelectQuery, ISqlExpression, string, ref bool)

BasicSqlBuilder.WrapColumnExpression(ISqlExpression)

BasicSqlBuilder.BuildAlterDeleteClause(SqlDeleteStatement)

BasicSqlBuilder.BuildDeleteClause(SqlDeleteStatement)

BasicSqlBuilder.BuildUpdateWhereClause(SelectQuery)

BasicSqlBuilder.BuildUpdateClause(SqlStatement, SelectQuery, SqlUpdateClause)

BasicSqlBuilder.BuildUpdateTable(SelectQuery, SqlUpdateClause)

BasicSqlBuilder.BuildUpdateTableName(SelectQuery, SqlUpdateClause)

BasicSqlBuilder.BuildUpdateSet(SelectQuery, SqlUpdateClause)

BasicSqlBuilder.BuildInsertClause(SqlStatement, SqlInsertClause, bool)

BasicSqlBuilder.BuildEmptyInsert(SqlInsertClause)

BasicSqlBuilder.BuildOutputSubclause(SqlStatement, SqlInsertClause)

BasicSqlBuilder.BuildOutputSubclause(SqlOutputClause)

BasicSqlBuilder.BuildInsertClause(SqlStatement, SqlInsertClause, string, bool, bool)

BasicSqlBuilder.BuildInsertOrUpdateQueryAsMerge(SqlInsertOrUpdateStatement, string)

BasicSqlBuilder.BuildInsertOrUpdateQueryAsUpdateInsert(SqlInsertOrUpdateStatement)

BasicSqlBuilder.BuildTruncateTable(SqlTruncateTableStatement)

BasicSqlBuilder.BuildDropTableStatementIfExists(SqlDropTableStatement)

BasicSqlBuilder.BuildStartCreateTableStatement(SqlCreateTableStatement)

BasicSqlBuilder.BuildCreateTableStatement(SqlCreateTableStatement)

BasicSqlBuilder.BuildCreateTableNullAttribute(SqlField, DefaultNullable)

BasicSqlBuilder.BuildCreateTableIdentityAttribute1(SqlField)

BasicSqlBuilder.BuildCreateTableIdentityAttribute2(SqlField)

BasicSqlBuilder.BuildCreateTablePrimaryKey(SqlCreateTableStatement, string, IEnumerable<string>)

BasicSqlBuilder.BuildDeleteFromClause(SqlDeleteStatement)

BasicSqlBuilder.BuildFromClause(SqlStatement, SelectQuery)

BasicSqlBuilder.BuildFromExtensions(SelectQuery)

BasicSqlBuilder.BuildPhysicalTable(ISqlTableSource, string, string)

BasicSqlBuilder.BuildSqlValuesTable(SqlValuesTable, string, out bool)

BasicSqlBuilder.BuildEmptyValues(SqlValuesTable)

BasicSqlBuilder.BuildTableName(SqlTableSource, bool, bool)

BasicSqlBuilder.BuildTableExtensions(SqlTable, string)

BasicSqlBuilder.BuildTableNameExtensions(SqlTable)

BasicSqlBuilder.GetExtensionBuilder(Type)

BasicSqlBuilder.BuildTableExtensions(StringBuilder, SqlTable, string, string, string, string)

BasicSqlBuilder.BuildTableExtensions(StringBuilder, SqlTable, string, string, string, string, Func<SqlQueryExtension, bool>)

BasicSqlBuilder.BuildQueryExtensions(StringBuilder, List<SqlQueryExtension>, string, string, string, Sql.QueryExtensionScope)

BasicSqlBuilder.BuildJoinTable(SelectQuery, SqlJoinedTable, ref int)

BasicSqlBuilder.BuildWhere(SelectQuery)

BasicSqlBuilder.BuildWhereClause(SelectQuery)

BasicSqlBuilder.BuildGroupByClause(SelectQuery)

BasicSqlBuilder.BuildGroupByBody(GroupingType, List<ISqlExpression>)

BasicSqlBuilder.BuildHavingClause(SelectQuery)

BasicSqlBuilder.BuildOrderByClause(SelectQuery)

BasicSqlBuilder.BuildExpressionForOrderBy(ISqlExpression)

BasicSqlBuilder.FirstFormat(SelectQuery)

BasicSqlBuilder.NeedSkip(ISqlExpression, ISqlExpression)

BasicSqlBuilder.NeedTake(ISqlExpression)

BasicSqlBuilder.BuildSkipFirst(SelectQuery)

BasicSqlBuilder.BuildTakeHints(SelectQuery)

BasicSqlBuilder.BuildOffsetLimit(SelectQuery)

BasicSqlBuilder.BuildWhereSearchCondition(SelectQuery, SqlSearchCondition)

BasicSqlBuilder.BuildSearchCondition(SqlSearchCondition, bool)

BasicSqlBuilder.BuildSearchCondition(int, SqlSearchCondition, bool)

BasicSqlBuilder.BuildPredicate(ISqlPredicate)

BasicSqlBuilder.BuildExprExprPredicateOperator(SqlPredicate.ExprExpr)

BasicSqlBuilder.BuildExprExprPredicate(SqlPredicate.ExprExpr)

BasicSqlBuilder.BuildIsDistinctPredicate(SqlPredicate.IsDistinct)

BasicSqlBuilder.BuildIsDistinctPredicateFallback(SqlPredicate.IsDistinct)

BasicSqlBuilder.BuildPredicate(int, int, ISqlPredicate)

BasicSqlBuilder.BuildLikePredicate(SqlPredicate.Like)

BasicSqlBuilder.BuildFieldTableAlias(SqlField)

BasicSqlBuilder.BuildExpression(ISqlExpression, bool, bool, string, ref bool, bool)

BasicSqlBuilder.TryConvertParameterToSql(SqlParameterValue)

BasicSqlBuilder.BuildParameter(SqlParameter)

BasicSqlBuilder.BuildExpression(ISqlExpression)

BasicSqlBuilder.BuildExpression(ISqlExpression, bool, bool, bool)

BasicSqlBuilder.BuildExpression(int, ISqlExpression)

BasicSqlBuilder.BuildTypedExpression(SqlDataType, ISqlExpression)

BasicSqlBuilder.BuildSqlRow(SqlRow, bool, bool, bool)

BasicSqlBuilder.BuildValue(SqlDataType, object)

BasicSqlBuilder.BuildBinaryExpression(SqlBinaryExpression)

BasicSqlBuilder.BuildFunction(SqlFunction)

BasicSqlBuilder.BuildDataType(StringBuilder, SqlDataType)

BasicSqlBuilder.BuildDataType(SqlDataType, bool, bool)

BasicSqlBuilder.GetPrecedence(ISqlPredicate)

BasicSqlBuilder.BuildTag(SqlStatement)

BasicSqlBuilder.BuildSqlComment(StringBuilder, SqlComment)

BasicSqlBuilder.AlternativeGetSelectedColumns(SelectQuery, IEnumerable<SqlColumn>)

BasicSqlBuilder.IsDateDataType(ISqlExpression, string)

BasicSqlBuilder.IsTimeDataType(ISqlExpression)

BasicSqlBuilder.GetSequenceNameAttribute(SqlTable, bool)

BasicSqlBuilder.GetTableAlias(ISqlTableSource)

BasicSqlBuilder.GetPhysicalTableName(ISqlTableSource, string, bool, string, bool)

BasicSqlBuilder.AppendIndent()

BasicSqlBuilder.PrintParameterName(StringBuilder, DbParameter)

BasicSqlBuilder.GetTypeName(IDataContext, DbParameter)

BasicSqlBuilder.GetUdtTypeName(IDataContext, DbParameter)

BasicSqlBuilder.PrintParameterType(IDataContext, StringBuilder, DbParameter)

BasicSqlBuilder.PrintParameters(IDataContext, StringBuilder, IEnumerable<DbParameter>)

BasicSqlBuilder.ApplyQueryHints(string, IReadOnlyCollection<string>)

BasicSqlBuilder.GetMaxValueSql(EntityDescriptor, ColumnDescriptor)

BasicSqlBuilder.RemoveAlias(string)

BasicSqlBuilder.GetTempAliases(int, string)

BasicSqlBuilder.BuildSqlID(Sql.SqlID)

BasicSqlBuilder.BuildMergeStatement(SqlMergeStatement)

BasicSqlBuilder.BuildMergeTerminator(SqlMergeStatement)

BasicSqlBuilder.BuildMergeOperationUpdate(SqlMergeOperationClause)

BasicSqlBuilder.BuildMergeOperationDelete(SqlMergeOperationClause)

BasicSqlBuilder.BuildMergeOperationInsert(SqlMergeOperationClause)

BasicSqlBuilder.BuildMergeOperationUpdateWithDelete(SqlMergeOperationClause)

BasicSqlBuilder.BuildMergeOperationDeleteBySource(SqlMergeOperationClause)

BasicSqlBuilder.BuildMergeOperationUpdateBySource(SqlMergeOperationClause)

BasicSqlBuilder.BuildMergeOn(SqlMergeStatement)

BasicSqlBuilder.BuildMergeSourceQuery(SqlTableLikeSource)

BasicSqlBuilder.BuildFakeTableName()

BasicSqlBuilder.BuildValues(SqlValuesTable, IReadOnlyList<ISqlExpression[]>)

BasicSqlBuilder.BuildMergeInto(SqlMergeStatement)

BasicSqlBuilder.OptimizationContext

BasicSqlBuilder.MappingSchema

BasicSqlBuilder.StringBuilder

BasicSqlBuilder.SqlProviderFlags

BasicSqlBuilder.DataOptions

BasicSqlBuilder.ValueToSqlConverter

BasicSqlBuilder.IsNestedJoinSupported

BasicSqlBuilder.IsNestedJoinParenthesisRequired

BasicSqlBuilder.CteFirst

BasicSqlBuilder.WrapJoinCondition

BasicSqlBuilder.InlineComma

BasicSqlBuilder.Comma

BasicSqlBuilder.OpenParens

BasicSqlBuilder.IsCteColumnListSupported

BasicSqlBuilder.SupportsBooleanInColumn

BasicSqlBuilder.UpdateKeyword

BasicSqlBuilder.UpdateSetKeyword

BasicSqlBuilder.OutputKeyword

BasicSqlBuilder.DeletedOutputTable

BasicSqlBuilder.InsertedOutputTable

BasicSqlBuilder.SkipFirst

BasicSqlBuilder.SkipFormat

BasicSqlBuilder.OffsetFirst

BasicSqlBuilder.TakePercent

BasicSqlBuilder.TakeTies

BasicSqlBuilder.Name

BasicSqlBuilder.TableIDs

BasicSqlBuilder.TablePath

BasicSqlBuilder.QueryName

BasicSqlBuilder.SupportsColumnAliasesInSource

BasicSqlBuilder.RequiresConstantColumnAliases

BasicSqlBuilder.IsValuesSyntaxSupported

BasicSqlBuilder.IsEmptyValuesSourceSupported

BasicSqlBuilder.FakeTable

BasicSqlBuilder.FakeTableSchema

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Extension Methods

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

SqlExtensions.In<T>(T, T, T, T)

SqlExtensions.In<T>(T, T, T)

SqlExtensions.In<T>(T, params T[])

SqlExtensions.In<T>(T, IEnumerable<T>)

SqlExtensions.In<T>(T, IQueryable<T>)

SqlExtensions.NotIn<T>(T, T, T, T)

SqlExtensions.NotIn<T>(T, T, T)

SqlExtensions.NotIn<T>(T, params T[])

SqlExtensions.NotIn<T>(T, IEnumerable<T>)

SqlExtensions.NotIn<T>(T, IQueryable<T>)

Constructors

PostgreSQLSqlBuilder(IDataProvider?, MappingSchema, DataOptions, ISqlOptimizer, SqlProviderFlags)

public PostgreSQLSqlBuilder(IDataProvider? provider, MappingSchema mappingSchema, DataOptions dataOptions, ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags)

Parameters

provider IDataProvider

mappingSchema MappingSchema

dataOptions DataOptions

sqlOptimizer ISqlOptimizer

sqlProviderFlags SqlProviderFlags

PostgreSQLSqlBuilder(BasicSqlBuilder)

protected PostgreSQLSqlBuilder(BasicSqlBuilder parentBuilder)

Parameters

parentBuilder BasicSqlBuilder

Properties

IdentifierQuoteMode

[Obsolete("Use PostgreSQLOptions.Default.IdentifierQuoteMode instead.")]
public static PostgreSQLIdentifierQuoteMode IdentifierQuoteMode { get; set; }

Property Value

PostgreSQLIdentifierQuoteMode

IsRecursiveCteKeywordRequired

protected override bool IsRecursiveCteKeywordRequired { get; }

Property Value

bool

SupportsNullInColumn

protected override bool SupportsNullInColumn { get; }

Property Value

bool

Methods

BuildCreateTableCommand(SqlTable)

protected override void BuildCreateTableCommand(SqlTable table)

Parameters

table SqlTable

BuildCreateTableFieldType(SqlField)

protected override void BuildCreateTableFieldType(SqlField field)

Parameters

field SqlField

BuildDataTypeFromDataType(SqlDataType, bool, bool)

Type could store NULL values (could be used for column table type generation or for databases with explicit typee nullability like ClickHouse).

protected override void BuildDataTypeFromDataType(SqlDataType type, bool forCreateTable, bool canBeNull)

Parameters

type SqlDataType

forCreateTable bool

canBeNull bool

BuildDropTableStatement(SqlDropTableStatement)

protected override void BuildDropTableStatement(SqlDropTableStatement dropTable)

Parameters

dropTable SqlDropTableStatement

BuildEndCreateTableStatement(SqlCreateTableStatement)

protected override void BuildEndCreateTableStatement(SqlCreateTableStatement createTable)

Parameters

createTable SqlCreateTableStatement

BuildGetIdentity(SqlInsertClause)

protected override void BuildGetIdentity(SqlInsertClause insertClause)

Parameters

insertClause SqlInsertClause

BuildInsertOrUpdateQuery(SqlInsertOrUpdateStatement)

protected override void BuildInsertOrUpdateQuery(SqlInsertOrUpdateStatement insertOrUpdate)

Parameters

insertOrUpdate SqlInsertOrUpdateStatement

BuildJoinType(SqlJoinedTable, SqlSearchCondition)

protected override bool BuildJoinType(SqlJoinedTable join, SqlSearchCondition condition)

Parameters

join SqlJoinedTable

condition SqlSearchCondition

Returns

bool

BuildObjectName(StringBuilder, SqlObjectName, ConvertType, bool, TableOptions, bool)

public override StringBuilder BuildObjectName(StringBuilder sb, SqlObjectName name, ConvertType objectType, bool escape, TableOptions tableOptions, bool withoutSuffix = false)

Parameters

sb StringBuilder

name SqlObjectName

objectType ConvertType

escape bool

tableOptions TableOptions

withoutSuffix bool

Returns

StringBuilder

BuildQueryExtensions(SqlStatement)

protected override void BuildQueryExtensions(SqlStatement statement)

Parameters

statement SqlStatement

BuildSql()

protected override void BuildSql()

BuildSubQueryExtensions(SqlStatement)

protected override void BuildSubQueryExtensions(SqlStatement statement)

Parameters

statement SqlStatement

BuildTruncateTableStatement(SqlTruncateTableStatement)

protected override void BuildTruncateTableStatement(SqlTruncateTableStatement truncateTable)

Parameters

truncateTable SqlTruncateTableStatement

Convert(StringBuilder, string, ConvertType)

public override StringBuilder Convert(StringBuilder sb, string value, ConvertType convertType)

Parameters

sb StringBuilder

value string

convertType ConvertType

Returns

StringBuilder

CreateSqlBuilder()

protected override ISqlBuilder CreateSqlBuilder()

Returns

ISqlBuilder

GetIdentityExpression(SqlTable)

public override ISqlExpression? GetIdentityExpression(SqlTable table)

Parameters

table SqlTable

Returns

ISqlExpression

GetProviderTypeName(IDataContext, DbParameter)

protected override string? GetProviderTypeName(IDataContext dataContext, DbParameter parameter)

Parameters

dataContext IDataContext

parameter DbParameter

Returns

string

GetReserveSequenceValuesSql(int, string)

public override string GetReserveSequenceValuesSql(int count, string sequenceName)

Parameters

count int

sequenceName string

Returns

string

IsReserved(string)

protected override sealed bool IsReserved(string word)

Parameters

word string

Returns

bool

IsSqlValuesTableValueTypeRequired(SqlValuesTable, IReadOnlyList<ISqlExpression[]>, int, int)

protected override bool IsSqlValuesTableValueTypeRequired(SqlValuesTable source, IReadOnlyList<ISqlExpression[]> rows, int row, int column)

Parameters

source SqlValuesTable

rows IReadOnlyList<ISqlExpression[]>

row int

column int

Returns

bool

LimitFormat(SelectQuery)

protected override string LimitFormat(SelectQuery selectQuery)

Parameters

selectQuery SelectQuery

Returns

string

OffsetFormat(SelectQuery)

protected override string OffsetFormat(SelectQuery selectQuery)

Parameters

selectQuery SelectQuery

Returns

string