postgres_dart library

Support for doing something awesome.

More dartdocs go here.

Classes

Aggregate
Aggregate functions such as Count, Sum, Avg, min and max columnName The Column being aggregated; ie, SUM("amount") where amount is the columnName label is used for the column name; ie: sum("amount") as myTotal, where myTotal is the label castToNumeric is used when the some or all the values in the columns are saved as String(varchar) but are numbers; converts "10" to 10
Avg
Avg returns the average for specified column
Column
columnName is the column name as in the table columnAs is name of the column on the response
ColumnDescription
A description of a column.
Count
Count returns the total row count for the query
DbResponse
Join
tableAs is an alias you can assign to the table for easier table reference; ie, if the table is named myTable, and given tableAs as mt Accessing columns can be mt.amount instead od myTable.amount
JoinOn
ON leftTable.column1 = rightTable.column2
JoinUsing
Using (columnName)
LSN
LSN is a PostgreSQL Log Sequence Number.
Max
Returns the maximum Value in the given column
Min
Returns the minimum Value in the given column
Notification
Represents a notification from PostgreSQL.
OnorUsing
OrderBy
For multiple order by, use OrderBy.and ie;
PgPoint
Describes PostgreSQL's geometric type: point.
PostgresDb
PostgreSQLConnection
Instances of this class connect to and communicate with a PostgreSQL database.
PostgreSQLExecutionContext
PostgreSQLFormat
PostgreSQLResult
The query result.
PostgreSQLResultRow
A single row of a query result.
PostgreSQLRollback
Represents a rollback from a transaction.
PostgresTable
Contains Table methods such as select, insert, inserMany, update, delete, deleteAll, min, max, count, sum, avg, aggregate, group, join
Sum
Sum returns the total sum for specified column
Where
Where("age", WhereOperator.isGreaterThan, 40); Where("age", WhereOperator.isGreaterThan, 40).and("gender", WhereOperator.isEqual, "M"); Where.not("age", WhereOperator.isGreaterThan, 40).and("gender", WhereOperator.isEqual, "M");

Enums

AggregateType
JoinType
PostgreSQLSeverity
The severity level of a PostgreSQLException.
ReplicationMode
Streaming Replication Protocol Options
WhereOperator

Typedefs

PostgreSQLDataType = PgDataType<Object>

Exceptions / Errors

PostgreSQLException
Exception thrown by PostgreSQLConnection instances.