relpipe-data/examples/sql-dk_pg_1.sh
branchv_0
changeset 255 94b533007e77
equal deleted inserted replaced
254:23247d93a012 255:94b533007e77
       
     1 sql-dk --db "$postgresql_db" --sql "
       
     2 SELECT
       
     3 	table_schema,
       
     4 	table_name,
       
     5 	table_type
       
     6 FROM information_schema.tables
       
     7 WHERE table_schema IN ('pg_catalog', 'information_schema')
       
     8 LIMIT 3;
       
     9 
       
    10 SELECT
       
    11 	typName,
       
    12 	typCategory,
       
    13 	typByVal
       
    14 FROM pg_type
       
    15 LIMIT 4" \
       
    16 	--relation tables \
       
    17 	--relation types \
       
    18 	--formatter xml \
       
    19 	| relpipe-in-xml