PostgreSQL

Connect to your PostgreSQL database with Postview using either connection details or a connection URI.

Connection Options

1. Connection Name*

The name that will be displayed in the connection sidebar. Choose a descriptive name that helps you identify this connection.

2. Connection Color

Set a color for the connection in the sidebar to help organize your connections. For example, use red for production databases or green for development environments.

3. Connection Details

Configure your PostgreSQL connection using the following fields:

Field	Description	Default
Host	The hostname or IP address of your PostgreSQL instance	-
Port	The port number of the PostgreSQL instance	`5432`
Username	The username for database authentication	`postgres`
Password	The password for the specified username	-
Database	The specific database to connect to (optional)	-

If you leave the Database field empty, you'll be prompted to select a database when establishing the connection.

4. Connection URI (Alternative)

Instead of filling out individual connection details, you can use a PostgreSQL connection URI:

postgresql://username:password@localhost:5432/database

Connection URIs are useful when you have a pre-configured connection string or when working with cloud database providers.

PostgreSQL Connection Setup

Next Steps

Once your PostgreSQL connection is configured:

Test the connection by clicking "Connect" to ensure all credentials are correct
Save the connection to add it to your sidebar
Start exploring your database and running queries