xtdb 2024-07-17

πŸ™‹ in v2, is there a way to get a list of tables by sending a SQL query to the /query resource?

Hey @aviflax yep πŸ™‚ try this:

curl --request POST \
  --url '' \
  --header 'Content-Type: application/json' \
  --data '{"sql": "SELECT table_name\nFROM information_schema.tables", "queryOpts": {"txTimeout": "PT1S", "keyFn": "SNAKE_CASE_STRING"}}'

at some point in the future you may want to add a WHERE table_type = 'BASE TABLE'; clause to that query unless you want to see VIEWS or other forms of tables in that list

Thank you!

☺️ 1