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.
Windows with their language set to Postgres will get syntax highlighting, and when there is connection selected: code completion, signature information, and diagnostics.
In Postgres language files you can run a query via F5, context menu, or command palette. You can also run a query from any other file type as long as a connection is selected and you have the query selected - F5 will not work for other file types.
Running queries in Postgres language files first check if anything is selected. If there is a selection, that is run as the query, otherwise all the queries in the editor are run.
Multiple queries are supported. If there is output from more than one query, multiple tables are shown in the results window.
Serializing Query Results
You can serialize your query results as well.
If you have more than one table of results, you will be prompted for the table you wish to serialize.
You can choose from three formats: json, xml, and csv. The results will be converted to the appropriate format and opened in a new editor of the selected type.
This extension contributes the following settings: