search

mtxr / vscode-sqltools

Database management for VSCode
https://vscode-sqltools.mteixeira.dev?utm_source=github&utm_medium=homepage-link
MIT License
1.52k stars 306 forks source link

Connect to multiple databases in postgresql #1152

Open umairshariff23 opened 1 year ago

umairshariff23 commented 1 year ago

Is your feature request related to a problem? Please describe. I currently have two test databases in my posgresql, test1 and test2. If I want to work in test1, I need to make sure that the connection settings specify that the test1 database is selected. When i need to switch to test2 database, I need to manually shift the connection to test2 database

Describe the solution you'd like I would like to see all of my databases in postgresql listed out so that I can query any database I want at any time. Additionally, I should be able to call data from any database to do cross database joins

Describe alternatives you've considered None

Additional context

zjustus commented 1 year ago

This would be a super helpful feature for all connectors. I have many MSSQL databases on a single server, it would be nice to pass an array of DB names or even be able to leave it blank to connect to all of them.

neckva commented 1 year ago

hello , i have 2 database on my server. I don't undestand how i can run a request on a selected database ? i work on maria db. thank you