# Using PostgreSQL client applications

> Compare PostgreSQL client tools such as psql, pgAdmin and phpPgAdmin for connecting to and managing your databases.

Source: https://helpcenter.ruachost.com/developers/databases/using-postgresql-client-applications/

> **PostgreSQL is available on Managed VPS only:**
Ruachost shared hosting supports MySQL (MariaDB) databases, not PostgreSQL. To use PostgreSQL, choose a [Managed VPS](https://ruachost.com/vps).

PostgreSQL client applications allow you to connect to and manage your databases. On **ruachost.com**, you can use both **command‑line tools** and **graphical interfaces** to interact with PostgreSQL.

## Why Use Client Applications?

- Simplify database management.
- Run queries, create tables, and manage users.
- Provide flexibility for developers and administrators.
- Support both local and remote connections.

## Common PostgreSQL Client Applications

### 1. **psql (Command Line)**

- Installed with PostgreSQL by default.
- Provides a powerful interactive terminal.
- Example usage:

  ```bash
  psql -U username -d dbname -h localhost
  ```
- Supports meta‑commands like `\dt` (list tables), `\q` (quit), and `\?` (help).

### 2. **pgAdmin (Graphical Interface)**

- A popular GUI for PostgreSQL.
- Allows you to manage databases visually.
- Features include query editor, backup/restore tools, and monitoring dashboards.
- Available for Windows, macOS, and Linux.

### 3. **phpPgAdmin (Web Interface)**

- Web‑based client similar to phpMyAdmin for MySQL.
- Accessible via **cPanel → Databases → phpPgAdmin**.
- Useful for quick database management without SSH access.
- Supports creating databases, running queries, and exporting/importing data.

### 4. **Third‑Party Tools**

- **DBeaver** – cross‑platform database management tool.
- **DataGrip** – JetBrains IDE for advanced database development.
- **HeidiSQL** – lightweight client supporting PostgreSQL.

-

> **Important Notes:**
- Ensure PostgreSQL is running before connecting.
- Use secure passwords and limit remote access to trusted IPs.
- Always back up databases before making major changes.