how to get desired html format output? - Mailing list pgsql-novice

From Anne Wainwright
Subject how to get desired html format output?
Date
Msg-id 20120809090749.GA8405@fables.co.za
Whole thread Raw
Responses Re: how to get desired html format output?
List pgsql-novice
Hello,

new here. i like the 'novice' list title, that about describes me.
part-time hacker, casual coder, would also be good descriptions.

have a one-table database holding descriptive records of catalogued
books.

normally I would output data in a delimited format and use a perl script
to do all the formatting to turn the  data into a full html table. I
have done this very successfully from my old database _but_ this would
export individual <field names> as field delimiters which made it easier
to write the script than, as with postgresql, where we have a uniformly
delimited output.

as a general road map. Is it possible to create output with all the
necessary html code for a table (font attributes and the like) direct
from postgresql (using a psql command)? One command and bingo, one table
ready to drop into my waiting html page?

would this normally be done perhaps with a file that could be called by
psql. This file with all the psql query commands/options and the html
formatting code within?

or should I rather create a new perl script to do the dirty?

if the former, can you please point me to some understandable 'howto' or
other documentation.

bestest & thanks for help

Anne

pgsql-novice by date:

Previous
From: Simon Riggs
Date:
Subject: Re: huge difference in TPS depending of synchornous_commit setting
Next
From: Jayadevan M
Date:
Subject: Re: how to get desired html format output?