PostgreSQL does not return a XML with table data

Asked Nov 23 '18 at 15:55

Active Nov 23 '18 at 16:26

Viewed 27 times

I am using the latest ProgreSQL on a iMac.

When I use a simple SQL statement for returning a XML from a table but it doesn't return the data.

SQL:

select table_to_xml('company',true,false,'');

(I also tried '"company"')

Returns only xml:

company xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

edited Nov 23 '18 at 16:26

asked Nov 23 '18 at 15:55

Chris Gerrist

That works: https://rextester.com/TJSBB41444 maybe your SQL client doesn't display multi line values properly – Nov 23 '18 at 16:09
You are right. I dump the output to a file and the records are visable. Strange that pgadmin not can handel the output of a query like this. Thanks a lot. Chris – Chris Gerrist Nov 23 '18 at 16:26

0 Answers0