relpipe-data/examples/sql-dk_pg_1.sh
branchv_0
changeset 255 94b533007e77
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/relpipe-data/examples/sql-dk_pg_1.sh	Mon Apr 08 13:37:35 2019 +0200
@@ -0,0 +1,19 @@
+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