postgresql

  psql "$POSTGRES_DATABASE_URI" -c "\copy table_name from 'file.csv' delimiter ',' csv header;"

  file="table.csv"; tail -n +2 $file | psql -d mydb -U postgres -W -h localhost -p 5432 -c
  "COPY landing_tbl ( $(head -n 1 $file) ) FROM STDIN CSV;"

  update new_table
  set field = b.field
  from backup b
  where  b.created_at = new_table.created_at and b.id = new_table.id and
  b.field is not null

  begin;
  create temporary table temp_mytable as
  select :fields_list
  from :dest_table
  where 1 <> 1;
  \copy temp_mytable from ':filename' delimiter ',' csv;
  insert into :dest_table(:fields_list)
  select
  :fields_list
  from temp_mytable
  on conflict (:pkey_fields_list)
  do update set
  :update_set;
  commit;

# Primero hay que levantar un proxy a la BBDD para conectarnos a ella en localhost:54321 (según el ejemplo)
psql "postgres://postgres:postgres@localhost:5432/postgres" -c "\copy tablename to tablename.csv delimiter ',' csv header"
pg_dump "postgres://postgres:postgres@localhost:5432/postgres" >  out.sql
psql "postgres://postgres:postgres@localhost:5432/postgres" < out.sql

export PGPASSWORD=yourpassword
pg_dump --verbose -h 127.0.0.1 -U db_user -p 5432 --format=custom --no-owner --no-acl -f database_name.dump database_name
pg_restore --verbose -p 5432 -U db_user -d database_name -h 127.0.0.1 --no-acl --no-owner -W database_name.dump

  GRANT SELECT ON TABLE public.elnombredelatabla TO el_usuario;
  revoke references ON TABLE public.nombredelatabla from el_usuarios;
  SELECT *
  FROM   information_schema.table_privileges
  where table_name = 'nombre_tabla'

GRANT CONNECT on DATABASE asuma TO developer;

GRANT SELECT ON ALL TABLES IN SCHEMA public TO developer;

GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO developer;

ALTER DEFAULT PRIVILEGES IN SCHEMA public
GRANT SELECT ON TABLES TO developer;

ALTER DEFAULT PRIVILEGES IN SCHEMA public
GRANT SELECT ON SEQUENCES TO developer;

REVOKE CREATE ON SCHEMA public FROM developer;

CREATE DATABASE EXAMPLE_DB;
CREATE USER EXAMPLE_USER WITH ENCRYPTED PASSWORD 'Sup3rS3cret';
GRANT ALL PRIVILEGES ON DATABASE EXAMPLE_DB TO EXAMPLE_USER;
\c EXAMPLE_DB postgres
-- You are now connected to database "EXAMPLE_DB" as user "postgres".
GRANT ALL ON SCHEMA public TO EXAMPLE_USER;
-- Para crear tablas tienes que darle este otro permiso
grant create on schema PUBLIC to example_user;
grant create on database example_db to example_user;

  select *
  from pg_stat_activity
  where datname = 'databasename';

  SELECT pg_cancel_backend(PID);
  SELECT pg_terminate_backend(PID); -- Mas fuerte

    min(err),
    percentile_disc(0.1) within group(order by err),
    percentile_disc(0.25) within group(order by err),
    percentile_disc(0.5) within group(order by err),
    avg(err),
    percentile_disc(0.75) within group(order by err),
    percentile_disc(0.9) within group(order by err),
    max(err),
    variance(err)