Postgresql Query return XML

[raranibar]

Hi List,

I like to know, How I can execute this query in Postgresql.
Postgresql has a command similar to ... for xml auto, elements ???

SELECT [CLI_ID],[CLI_FIRSTNAME],[CLI_LASTNAME],[CLI_TELEPHONE]
      ,[CLI_BIRTHDATE] ,[CLI_SEX],[CLI_STATUS]
  FROM [MDSistemadeSeguros].[dbo].[CLIENTS] for xml auto,elements

Because I like have this result in XML

<MDSistemadeSeguros.dbo.CLIENTS>
  <CLI_ID>2</CLI_ID>
  <CLI_FIRSTNAME>MARIAELIGIA</CLI_FIRSTNAME>
  <CLI_LASTNAME>CHAVEZ</CLI_LASTNAME>
  <CLI_TELEPHONE>239/2313102</CLI_TELEPHONE>
  <CLI_BIRTHDATE>1965-07-22T00:00:00</CLI_BIRTHDATE>
  <CLI_SEX>Masculino</CLI_SEX>
  <CLI_STATUS>Desconocido</CLI_STATUS>
</MDSistemadeSeguros.dbo.CLIENTS>

[rski]

See here

http://www.postgresql.org/docs/8.4/interactive/functions-xml.html