0

I need to get table metadata like primary key, column type etc. using PostgRest. By executing the root path / of my PostgRest app I am getting JSON that contains all needed data in definitions object.

Unfortunately there is no endpoint to get it and there is no information about that in documentation.

I have tried to execute the following endpoints: /table/parameters /table/definitions /table/schema

All returns 404 error code.

Is there any way to get metadata?

Jake Cooper
  • 21
  • 5

1 Answers1

0

You'd have to write a view or function and call it. In that SQL return the metadata from anything in your db.

grantwparks
  • 1,124
  • 9
  • 13