PostgreSQL: Using the PostgreSQL psql CLI

This documentation is part of the Getting started guide. View the full guide here: How to get started with PostgreSQL.

👋 Welcome to the Stackhero documentation!

Stackhero provides a fully managed PostgreSQL cloud service, designed for reliability and speed:

  • Unlimited connections and data transfers for seamless scaling.
  • PgAdmin web UI included for intuitive database management.
  • Popular extensions included, such as PostGIS, TimescaleDB, and PgVector.
  • Simple, one-click updates keep your database secure and current.
  • High performance and strong security on private, dedicated infrastructure.

You can get started with Stackhero's PostgreSQL cloud hosting in just a few minutes. Enjoy a reliable database experience and save valuable time managing your data.

You can manage PostgreSQL with its official psql CLI. It is available for installation on your computer, allowing you to manage your PostgreSQL service remotely. Alternatively, you can run it via Docker. This method is often preferred because it avoids installing psql directly on your computer and makes it easier to switch between versions.

To access psql using Docker, run the following command (make sure to replace 18 with the major version number of your PostgreSQL service):

docker run -v $(pwd):/mnt -it postgres:18-alpine /bin/bash

Then connect to your PostgreSQL service using:

cd /mnt
psql \
  --host=<XXXXXX>.stackhero-network.com \
  --username=admin \
  --port=<PORT> \
  --dbname=admin

Continue reading this guide

  1. Read the full guide: Getting started
    How to get started with PostgreSQL
  2. Creating a user and database in PostgreSQL
  3. Importing data from your computer to PostgreSQL
  4. Exporting data from PostgreSQL to your computer
  5. Using PostgreSQL with Node.js
  6. Using PostgreSQL with Node.js/TypeORM
  7. Using PostgreSQL with Django
  8. Activating PostgreSQL PostGIS extension
  9. Deactivating PostgreSQL PostGIS extension
  10. Activating PgVector extension
  11. Activating TimescaleDB extension
  12. Tracking statistics of SQL planning and execution (pg_stat_statements)
  13. Configuring PostgreSQL with Skyvia

Other articles for PostgreSQL

  1. ElephantSQL shutdown alternative
    Smoothly migrate from ElephantSQL: Stackhero offers a secure, dedicated PostgreSQL service.
  2. Automate with the CLI
    Start PostgreSQL, retrieve its credentials, and change its configuration programmatically with the Stackhero CLI
  3. GitHub Actions & GitLab CI
    Spin up a real PostgreSQL service from your GitHub Actions or GitLab CI pipeline, run your tests against it, and tear it down automatically