PostgreSQL

Execute a SELECT query and return results as JSON

3 fields

Execute an INSERT, UPDATE, DELETE, or other non-SELECT statement

3 fields

Execute a statement with multiple parameter sets (batch operations)

2 fields

Execute query with cursor for large result sets

4 fields

Bulk import data to a table using COPY

4 fields

Bulk export data from a table using COPY

5 fields

List all tables in a schema

2 fields

Get column metadata for a table

2 fields

Get detailed information about a table including constraints and indexes

2 fields

Create a new table

4 fields

Drop a table

4 fields

Truncate a table (remove all rows)

4 fields

Create a new schema

2 fields

Drop a schema

3 fields

List all indexes in a schema

2 fields

Create an index on a table

6 fields

Drop an index

3 fields

List all views in a schema

1 field

Create a view

4 fields

Drop a view

3 fields

List all sequences in a schema

1 field

Get the next value from a sequence (nextval)

2 fields

Get the current value from a sequence (currval)

2 fields

Set the current value of a sequence (setval)

4 fields

List all functions in a schema

1 field

Call a PostgreSQL function

3 fields

List all constraints for a table

2 fields

List all triggers in a schema

2 fields

Create/install an extension

3 fields

Explain a query's execution plan

3 fields

Vacuum a table to reclaim storage and update statistics

4 fields

Analyze a table to update statistics

2 fields

Begin a new transaction

1 field