How can I export a PostgreSQL table to HTML?

Question

How can I save a PostgreSQL table to HTML?

Answer 1

Here is an example of an XML "forest":

SELECT xmlforest (
  "FirstName" as "FName", "LastName" as "LName",
  ’string’ as "str", "Title", "Region" )
FROM "Demo"."demo"."Employees";

With some data in the employees table, this might result in:

<FName>Nancy</FName>
<LName>Davolio</LName>
<str>string</str>
<Title>Sales Representative</Title>
<Region>WA</Region>
...
<FName>Anne</FName>
<LName>Dodsworth</LName>
<str>string</str>
<Title>Sales Representative</Title>

http://wiki.postgresql.org/wiki/XML_Support

Answer 2

I'll take a stab at assuming what you mean. In psql:

dbname=# \H
dbname=# \d tablename