DBweaver:
The community edition is free. It will address most of the common functionality one may need.
Microsoft Excel:
Note: Before you can connect to a PostgreSQL database in Power Query, you need the Ngpsql data provider for PostgreSQL installed on your computer. Select the driver that matches your Office version (32-bit or 64-bit). See: Which version of Office am I using? for more information. Also make sure you have the provider registered in the machine configuration that matches the most recent .NET version on your device.
1. Click the Data tab, then Get Data > From Database > From PostgreSQL Database. If you don't see the Get Data button, then click on New Query > From Database > From PostgreSQL Database.
2. In the PostgreSQL Database dialog box, specify the PostgreSQL Database Server you want to connect to in the Server Name section.
3. If you want to import data using native database query, specify your query in the SQL Statement box. For more information, see Import Data from Database using Native Database Query.
4. Select OK.
5. If the PostgreSQL server requires database user credentials:
a. In the Access a Database dialog box, enter your username and password.
b. Select Connect.
Microsoft MS SQL Server Management Studio:
Using Management Studio to connect to PostgreSQL - https://www.devart.com/odbc/postgresql/docs/microsoft_sql_server_manager_s.htm
It is a free download from:
pgAdmin:
Depending on whether one mostly needs to perform admin. or query/script development, it may not have everything one requires … but one should certainly check it out.
Available from https://www.pgadmin.org/
No comments:
Post a Comment