plpgsql_ex_abc_criar_tabela

CREATE schema abc; /* se necessário */

DROP TABLE IF EXISTS abc.conta;

CREATE TABLE abc.conta (
  id int generated BY DEFAULT AS identity,
  nome VARCHAR(100) NOT NULL,
  saldo numeric(15, 2) NOT NULL,
  primary key(id)
);

INSERT INTO abc.conta(nome, saldo) VALUES ('Goku', 10000);
INSERT INTO abc.conta(nome, saldo) VALUES ('Frodo', 10000);