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. In Postgres language files you can run a query via F5, context menu, or 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. You can also initiate the change from the command palette. All windows start with no connection selected.Ĭlicking on the server ("localhost" above) or the database name will allow you to quickly change the database. Running QueriesĮach editor window can have a different database and/or connection used for its queries. The latter option will prompt you for the quantity first. They both open a new query with a "SELECT *" query started and run it. Tables have the extra option to "Select Top 1000" or "Select Top.". 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. You can remove connections from the connection context menu or the command palette command "PostgreSQL: Delete Connection".Įach 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"). You can add a PostgreSQL connection in the explorer or via the command palette command "PostgreSQL: Add Connection"
0 Comments
Leave a Reply. |