· 7 years ago · Jan 03, 2019, 09:06 PM
1CREATE USER meuusuario WITH PASSWORD 'a';
2CREATE DATABASE meudatabase;
3GRANT ALL PRIVILEGES ON DATABASE meudatabase TO meuusuario;
4
5\connect meudatabase
6
7CREATE EXTENSION IF NOT EXISTS hstore WITH SCHEMA public;
8
9CREATE TABLE minhatabela (
10 tabela_a bigint NOT NULL,
11 tabela_b hstore
12);
13
14GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO meuusuario;