psql postgres postgres
CREATE ROLE pacman PASSWORD 'pacman';
CREATE DATABASE pacman OWNER pacman;
\q

psql pacman pacman

CREATE TABLE a 
(
	  id int NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY, 
	, data text
	, length numeric
	-- , createdby int -- WHO
	-- , createdat timestamptz DEFAULT NOW() -- WHEN
);

INSERT INTO a VALUES (DEFAULT, 'a', 100) RETURNING id;
\q

SELECT * FROM a;
SELECT 
    id AS aid
  , data AS content
  , length AS length
FROM
  a
WHERE
  a.id=1
  

CREATE PROCEDURE insert_data(a integer, b integer)
LANGUAGE SQL
AS $$
INSERT INTO a VALUES (a);
INSERT INTO tbl VALUES (b);
$$;

CALL insert_data(1, 2);