Thanks I am trying as below ; db_name=# select table_to_xml(tbl master, nulls boolean, tableforest boolean, targetns text); ERROR: syntax error at or near "master" LINE 1: select table_to_xml(tbl master, nulls boolean, tableforest b... ^ Do I need to use both functions
Craig Ringer wrote: On 8/09/2011 2:41 PM, Adarsh Sharma wrote: Dear all, Today I need to write the output of an postgres table into XML format. I think there is an easiest way to do this but not able to find it.http://www.postgresql.org/docs/current/static/functions-xml.html Use the query_to_xml or table_to_xml functions. -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general
On 8/09/2011 2:41 PM, Adarsh Sharma wrote: Dear all, Today I need to write the output of an postgres table into XML format. I think there is an easiest way to do this but not able to find it.http://www.postgresql.org/docs/current/static/functions-xml.html Use the query_to_xml or table_to_xml functions. -- Craig Ringer
Dear all, Today I need to write the output of an postgres table into XML format. I think there is an easiest way to do this but not able to find it.
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных