get all columns of a table

[y0zong]

hi, I'm new to postgrest, I need to get all columns from a table and can't find any detail from document, so how to make this work with postgrest? and what about add/delete column with postgrest?

[gregwebs]

For the columns, you are trying to get those from the API rather than a tool directly connected to the DB? Maybe you would fine that from the OpenAPI definitions?

[wolfgangwalther]

and what about add/delete column with postgrest?

PostgREST is not designed for DDL.

[steve-chavez]

Can be done with pg_meta - this extension exposes a column view that can be inserted/deleted. If you isolate this on a schema plus give it the right privileges, it should be fine to expose through postgREST.