|
CREATE TABLE customers (
id int NOT NULL,
first_name VARCHAR(50) NOT NULL,
last_name VARCHAR(50) NOT NULL,
city VARCHAR(50) NOT NULL,
state VARCHAR(5),
PRIMARY KEY (id)
);
INSERT INTO customers (id, first_name, last_name, city, state)
VALUES
(1, 'François', 'Tremblay', 'Montreal', 'QC'),
(2, 'Bjørn', 'Hansen', 'Oslo',null),
(3, 'Helena', 'Holý', 'Prague', null),
(4, 'Fernanda', 'Ramos', 'Brasília', 'DF');
SELECT query_to_xml(
'SELECT t.id "Id"
, t.first_name "FirstName"
, t.last_name "LastName"
, t.city "City"
, t.state "State"
FROM customers t LIMIT 2', true , false, '')
query_to_xml |
<table xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<row>
<Id>1</Id>
<FirstName>François</FirstName>
<LastName>Tremblay</LastName>
<City>Montreal</City>
<State>QC</State>
</row>
<row>
<Id>2</Id>
<FirstName>Bjørn</FirstName>
<LastName>Hansen</LastName>
<City>Oslo</City>
<State xsi:nil="true"/>
</row>
</table>
|
… |
|