API Reference
Endpoints of the API
prestd automatically generates an API based on the structure of the connected database (Postgres), in this API reference session you will understand all the endpoints, parameters, advanced methods, auth and much more.
prestd implements all http verbs, transcribing to SQL ANSI (American National Standards Institute) statements.
GET
Postgres
SELECT
instruction
Endpoints | Description |
---|---|
| Health check endpoint |
| List all databases |
| List all schemas |
| List all tables |
| Lists table structure - all fields contained in the table |
| Lists table tables - find by schema |
| List all rows, find by database, schema and table |
| List all rows, find by database, schema and view |
POST
Postgres
INSERT
instruction
JSON DATA:
PATCH and PUT
Postgres
UPDATE
instruction
Using query string to make filter (WHERE), example:
JSON DATA:
unconditional
update
can update unwanted record
DELETE
Postgres
DELETE
instruction
Using query string to make filter (WHERE), example:
unconditional
delete
can delete unwanted record
Last updated