All notable changes to the "vscode-postgres" extension will be documented in this file.
- Sidebar icon has been updated and should now size correctly for vscode 1.37.0.
- Add DB connection process now handles more issues with connecting to a possibly secured
postgresdatabase (issue #97).
- Add DB connection process has been altered to be more user friendly. Also fixes ssl cert issues (issue #66).
- PG 11 Version issues for language server (issue #92).
- Delete results now properly show RETURNING data (issue #91).
- Syntax highlighting when first character of query is a space (issue #79) by @votagus.
- Capability to better separate main queries by pg version
- Support for default connections using settings which can be overridden at the project level (issue #69)
- To better support default connections, the extension now activates on start vs. when a view/language/command is accessed for the first time.
- Support of PG 11 in function explorer (issue #72)
Functionsvirtual folder (must enable in configuration) by @lafriks- Added schemas to autocompletion by @lafriks
- Better hiding of
pg_tempandpg_toasttables by @lafriks
- Better support for blank passwords - doesn't touch Keytar (thanks to @SWW13)
- Performance opening table to show columns degraded when the column query when support was added for v9.3. Version detection was put in to allow a better performing query to work on 9.4+.
- Support for PostgreSQL 9.3
prettyPrintJSONfieldssetting should work again
- Transitioned result pane from using TextDocumentContentProvider to using Webviews.
- Serialize results to JSON and XML should work properly again (broke with fix in 1.0.15).
- Support for
circleandpointgeometric types. - All query results now use the result pane.
- Explain statements should now work again (broke with fix in 1.0.15)
- Icon for foreign keys in the database explorer.
- Display formatted type names in results grid headers by @lnicola
- Display of results when running queries with multiple columns of the same name.
- Display of
intervaldata formats - Changed using namespace name to oid for issue #33
- Support for optionally providing a database when creating a connection (ends up with a single-database connection in the db explorer).
- Added configuration setting to control the sort order of table columns: database order, alphabetical, and reverse alpha.
- Quoted schemas/tables in priviledge queries.
- Support for editing connection details.
- Preserve query focus code was spawning a new query editor.
- Windows bug causing "cannot read property of null" errors - solved simultaneously with @Yarith
- Info/Error node - if an error occurred when expanding a node in the database explorer there wasn't an indication of what went wrong
- Support for PostgreSQL user permissions. Databases, schemas, tables, views should all be filtered based on the user used when setting up the connection.
- Support for quoted identifiers
- Option to disable changing active connection when navigating the explorer by @mterring
- Schema support to table nodes and capitalized table names by @jgoday
- Code Completion: grouped fields of the same data type together and show all the tables/views they belong to in a list
- Status bar text when connection is not labelled
- Display label for postgres connections by @peterbam
- Rename command for display label
- Show "Run Query" command errors using notifications
- Support for DB Views in the database explorer and code completion
- Support for custom activity bar
- Connection button, now properly asks for the connection instead of the database.
- Syntax highlighting
- Connection aware code completion (keywords, functions, tables, and fields)
- In-line error detection powered by EXPLAIN (one error per query in editor)
- Basic function signature support (connection aware)
- Repository link
- Output Console Name for Language Service
- Ability to save results to JSON, XML, or CSV.
- Initial release