This is a query tool for PostgreSQL databases. While there is a database explorer it is NOT meant for creating/dropping databases or tables. The explorer is a visual aid for helping to craft your queries.
There is a language service that should keep at most a single connection open to the database (assuming one was selected). This facilitates query diagnostics, code completion, and function signatures. All code completion keywords, functions, tables, and field names are pulled from the current connection to try to keep everything relevant.
It is possible there are some queries that won't run and report problems - even if they are completely valid (
You can add a PostgreSQL connection in the explorer or via the command palette command "PostgreSQL: Add Connection"
You can remove connections from the connection context menu or the command palette command "PostgreSQL: Delete Connection".
Each item in the explorer has it's own context menu, and you can start a new query from any level (or the command palette "PostgreSQL: New Query").
The "Refresh Items" option reloads the sub-nodes for that item, useful if there were structural changes to the database and you want the explorer to reflect them.
Tables have the extra option to "Select Top 1000" or "Select Top...". They both open a new query with a "SELECT *" query started and run it. The latter option will prompt you for the quantity first.
Each editor window can have a different database and/or connection used for its queries. All windows start with no connection selected.
Clicking on the server ("localhost" above) or the database name will allow you to quickly change the database. You can also initiate the change from the command palette.
Loading More data ...