To connect to a remote PostgreSQL database using the psql command-line utility, you need to specify the connection details such as the host, port, username, and database name. Here’s the general syntax for connecting to a remote PostgreSQL database:

psql -h <host> -p <port> -U <username> -d <database>

• <host>: The hostname or IP address of the remote server where PostgreSQL is running.
• <port>: The port number where PostgreSQL is listening. The default is 5432.
• <username>: The username to connect to the database.
• <database>: The name of the database you want to connect to.

If your remote PostgreSQL server requires a password for the specified user, psql will prompt you to enter it after you execute the command.

Here’s an example of connecting to a remote PostgreSQL database:

psql -h myserver.example.com -p 5432 -U myuser -d mydatabase

After running this command, you’ll be prompted to enter the password for the specified user. If the credentials are correct, you’ll be connected to the remote PostgreSQL database, and you can start executing SQL commands.

If you want to provide the password as part of the command (not recommended for security reasons), you can use the -W option like this:

psql -h myserver.example.com -p 5432 -U myuser -d mydatabase -W

Please note that it’s generally considered more secure to let psql prompt you for the password rather than including it in the command, especially if you’re scripting or automating database tasks, as hardcoding passwords in scripts can be a security risk.