The general form of a connection URI in PostgreSQL:
postgresql://[user[:password]@][netloc][:port][,...][/dbname][?param1=value1&...]
Some examples of valid PostgreSQL URI:
postgresql://
postgresql://localhost
postgresql://localhost:5433
postgresql://localhost/mydb
postgresql://user@localhost
postgresql://user:secret@localhost
postgresql://other@localhost/otherdb?connect_timeout=10&application_name=myapp
postgresql://host1:123,host2:456/somedb?target_session_attrs=any&application_name=myapp
The URI scheme designator can be either postgresql:// or postgres://.
In TablePlus, when creating a new connection, you can choose to import directly from URI instead of filling in credentials manually. That's a much faster and hassle-free option to create a connection.
*Need a good GUI Tool for PostgreSQL? TablePlus is a modern, native tool with an elegant UI that allows you to simultaneously manage multiple databases such as MySQL, PostgreSQL, SQLite, Microsoft SQL Server and more. *
Not on Mac? Download TablePlus for Windows.
On Linux? Download TablePlus for Linux
Need a quick edit on the go? Download TablePlus for iOS.
