relpipe-data/examples/sql-dk_pg_1.sh
author František Kučera <franta-hg@frantovo.cz>
Tue, 04 Aug 2020 00:59:32 +0200
branchv_0
changeset 313 a43265235e5a
parent 255 94b533007e77
permissions -rwxr-xr-x
examples: Monitoring MIDI messages using JACK – relpipe-in-jack: @id for the MT-32 part

sql-dk --db "$postgresql_db" --sql "
SELECT
	table_schema,
	table_name,
	table_type
FROM information_schema.tables
WHERE table_schema IN ('pg_catalog', 'information_schema')
LIMIT 3;

SELECT
	typName,
	typCategory,
	typByVal
FROM pg_type
LIMIT 4" \
	--relation tables \
	--relation types \
	--formatter xml \
	| relpipe-in-xml