Is It Possible To Have An XML Output by a Query

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Gerolamo
    New Member
    • Feb 2019
    • 1

    Is It Possible To Have An XML Output by a Query

    Hi to All,

    I have a table articles.
    If I made the simple query:
    Code:
    SELECT name, quantity
    From articles;
    I obtain the name and the relative quantity of each row in the table articles.

    But, now the question is:
    Is it possible to make a query in order to obtain the XML output of the same query?
    If yes, what i s the sintax?

    Tanks in advance.
    Gerolamo
  • Luuk
    Recognized Expert Top Contributor
    • Mar 2012
    • 1043

    #2
    Code:
    SELECT query_to_xml('select ...',false,false,'');
    Sorry for the short answer, but did you RTFM

    Comment

    Working...