supabase / dbdev

Database Package Registry for Postgres
https://database.dev/
Apache License 2.0
370 stars 19 forks source link

Document How to List Installed Extensions #197

Open tmountain opened 2 months ago

tmountain commented 2 months ago

Improve documentation

Link

https://github.com/supabase/dbdev

Describe the problem

There's nothing in the docs showing how to list installed packages. I had to dig through the CLI source code to find out how to do this.

Describe the improvement

Update the docs to inform users that they can run this query.

select name, default_version from pgtle.available_extensions()

Update the docs to inform users that the CLI supports this as well (example using local dev).

dbdev list --connection 'postgresql://postgres:postgres@localhost:54322/postgres'

Additional context

Docs for basic package management should always include install, list, update, and removal of packages.