bash-4.2$ psql mydb
psql (10.4)
Введите "help", чтобы получить справку.

mydb=# select * from amqp.broker;
 broker_id |   host    | port | vhost | username | password
-----------+-----------+------+-------+----------+----------
         1 | localhost | 5672 |       |          |
(1 строка)

mydb=# \dt amqp.*
          Список отношений
 Схема |  Имя   |   Тип   | Владелец
-------+--------+---------+----------
 amqp  | broker | таблица | postgres
(1 строка)

mydb=# \q

bash-4.2$ pg_dump --format=plain -d mydb -n amqp
--
-- PostgreSQL database dump
--

-- Dumped from database version 10.4
-- Dumped by pg_dump version 10.4

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: amqp; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA amqp;


ALTER SCHEMA amqp OWNER TO postgres;

--
-- Name: SCHEMA amqp; Type: ACL; Schema: -; Owner: postgres
--

GRANT USAGE ON SCHEMA amqp TO testuser;


--
-- PostgreSQL database dump complete
--

bash-4.2$

SELECT pg_catalog.pg_extension_config_dump('broker', '');