query
--------------------
select 
	'text'::text, 'varchar'::varchar, 'varchar10'::varchar(10), 'char10'::char(10), 
	1::bit, '10101010000111101101'::varbit, '10101111011'::varbit(15), 
	true::boolean, 
	'134514514511111.10'::money, '22222.20'::numeric(18,2), '333333'::numeric(18), '444444'::numeric, 
	'<root/>'::xml, 
	ARRAY[[1,2,3],[9,8,7]]::int[][]


result
--------------------
field text value text
 type 10 typeid 25 length -1 precision -1


field varchar value varchar
 type 10 typeid 1043 length -1 precision -1


field varchar value varchar10
 type 10 typeid 1043 length 10 precision -1


field bpchar value char10    
 type 10 typeid 1042 length 10 precision -1


field bit value 1
 type 10 typeid 1560 length 1 precision -1


field varbit value 10101010000111101101
 type 10 typeid 1562 length -1 precision -1


field varbit value 10101111011
 type 10 typeid 1562 length 15 precision -1


field bool value true
 type 1 typeid 16 length 1 precision -1


field money value $134,514,514,511,111.10
 type 10 typeid 790 length 8 precision -1


field numeric value 22222.2
 type 6 typeid 1700 length 18 precision 2


field numeric value 333333
 type 6 typeid 1700 length 18 precision 0


field numeric value 444444
 type 6 typeid 1700 length -1 precision -1


field xml value <root/>
 type 10 typeid 142 length -1 precision -1


field array value {{1,2,3},{9,8,7}}
 type 10 typeid 1007 length -1 precision -1