SQL (PostgreSQL)

SELECT version();</sql>
<code sql>SELECT * FROM «pg_user»;

CREATE USER nombre_usuario WITH password ‘123456';

DROP USER nombre_usuario;

ALTER USER usertochange WITH password ‘new_passwd’;

ALTER USER mysuper WITH SUPERUSER;
ALTER USER mysuper WITH SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN REPLICATION;

CREATE DATABASE nombre_db WITH OWNER nombre_usuario;

DROP DATABASE nombre_db;

ALTER DATABASE database_name OWNER TO new_owner;

SELECT pg_size_pretty(pg_database_size(‘dbname’));

TRUNCATE TABLE TABLE RESTART IDENTITY;

COPY (SELECT * FROM tablename) TO '/home/tablename.csv' WITH DELIMITER '|';