docs:servicios:postgres:inicio

Postgres

 postgres=# CREATE USER employee WITH PASSWORD 'superPass0';
 CREATE ROLE
 postgres=# CREATE DATABASE employee OWNER employee;
 CREATE DATABASE
 
 \l
 postgres=# \c employee
 You are now connected to database "employee" as user "postgres".
 
 planka=# GRANT CONNECT ON DATABASE employee TO employee;
 GRANT
 
 planka=# GRANT USAGE ON SCHEMA public TO employee;
 GRANT
 
 planka=# GRANT CREATE ON SCHEMA public TO employee;
 GRANT
 psql -h TU_SERVIDOR -U employee -d employee -W

Ref: https://commandprompt.com/education/how-to-create-a-postgresql-database-in-docker/

  • docs/servicios/postgres/inicio.txt
  • Última modificación: 2025/05/06 02:46
  • por rodolfo