Endpoints

prestd implements all http verbs, transcribing to SQL ANSI (American National Standards Institute) statements.

GET

Postgres SELECT instruction

Endpoints Description
/_health Health check endpoint
/databases List all databases
/schemas List all schemas
/tables List all tables
/show/{DATABASE}/{SCHEMA}/{TABLE} Lists table structure - all fields contained in the table
/{DATABASE}/{SCHEMA} Lists table tables - find by schema
/{DATABASE}/{SCHEMA}/{TABLE} List all rows, find by database, schema and table
/{DATABASE}/{SCHEMA}/{VIEW} List all rows, find by database, schema and view

POST

Postgres INSERT instruction

/{DATABASE}/{SCHEMA}/{TABLE}

JSON DATA:

{
    "FIELD1": "string value",
    "FIELD2": 1234567890
}

PATCH and PUT

Postgres UPDATE instruction

Using query string to make filter (WHERE), example:

/{DATABASE}/{SCHEMA}/{TABLE}?{FIELD NAME}={VALUE}

JSON DATA:

{
    "FIELD1": "string value",
    "FIELD2": 1234567890,
    "ARRAYFIELD": ["value 1","value 2"]
}

unconditional update can update unwanted record

DELETE

Postgres DELETE instruction

Using query string to make filter (WHERE), example:

/{DATABASE}/{SCHEMA}/{TABLE}?{FIELD NAME}={VALUE}

unconditional delete can delete unwanted record