Postgres & PGAdmin

Postgres Database

The project uses a PostgreSQL database running in a Docker container.

• Service Name: postgres
• Port: 5432
• Data Volume: postgres_data

PGAdmin

PGAdmin is used for database management and administration.

• Service Name: pgadmin
• URL: https://pgadmin.lage-beauty.de
• Credentials: Configured in bitwarden.

Accessing the Database

You can access the database using PGAdmin client using the credentials defined in bitwarden.

To find the database tables navigate: Servers -> Postgres -> Databases -> lage_db -> Schemas -> public -> Tables

Query

To query on all of the tables, right click on "Tables" and select the Query Tool (alternativ you can use Alt + Shift + Q).

Example Query: select * from articles