Module scooby::postgres [−][src]
Expand description
Implementation of PostgreSQL dialect of SQL, including some PostgreSQL specific features and tools.
Supported statements
See each function’s docs for details on supported clauses and features.
| Entry function | SQL statement |
|---|---|
select | SELECT |
insert_into | INSERT INTO |
delete_from | DELETE FROM |
update | UPDATE |
with | WITH |
Tools
| Tool | Description |
|---|---|
Parameters | Generator of query parameter placeholders |
Modules
Bits that are usable in different types of queries
Specific query related functions, types and traits.
PostgreSQL-specific tools to make your life easier
Structs
DELETE FROM statement, possibly with additional clauses.
INSERT INTO statement with a VALUES clause, and possibly additional clauses.
Generator of PostgreSQL parameter placeholders for dynamic queries with multiple values
SELECT statement, possibly with additional clauses.
UPDATE statement with at least one set of values, and possibly additional clauses.
Traits
Things that may be aliased x AS y style
Things that can be JOIN’d upon
Things that can have ORDER BY clause options applied to them
Functions
Create a new DELETE FROM statement with the given table name.
Start building a new INSERT INTO statement with the given table name.
Create a new SELECT statement with given expressions.
Start building a new UPDATE statement with the given table name.
Start a new WITH clause for Common Table Expressions