Uwaga musi byc USER: postgres (bo potem przy imporcie bazy (restore) sie sapie)
version: "3.8"
services:
postgresql:
image: postgres:14.4
restart: always
ports:
- 5432:5432
environment:
POSTGRES_PASSWORD: sqlhaslo
POSTGRES_USER: postgres
POSTGRES_DB: sqlbaza
pgadmin:
image: dpage/pgadmin4:latest
restart: always
ports:
- 5050:80
environment:
PGADMIN_DEFAULT_EMAIL: [email protected]
PGADMIN_DEFAULT_PASSWORD: sqlhaslo
2. Import bazy do pgadmin
Plik tar mozna po prostu przeciagnac tam w resotre opcji z kompa
SELECT first_name FROM customer;
SELECT first_name || ' ' || last_name, email FROM curstomer;
Pozwala na nazwanie wyniku.
SELECT first_name || ' ' || last_name AS full_name FROM customer;
SELECT first_name || ' ' || last_name AS "full name" FROM customer;