Actually I'm one of those who thinks these sort of features (including the
existing html display stuff) don't belong in psql.
It's much better to use a different tool to do it (e.g. a perl, php, java,
C++, etc program, a reporting tool, and so on).
By the time you need fancier display features than what psql already
provides you usually would be looking for something less "rube
goldbergish". Then again, I mentioned perl (and use it) so feel free to
ignore me :).
Seriously tho, when you start to get more users you might find that
shell+psql+sed+sed+sed+etc strung together won't be able to keep up with
the load.
Cheerio,
Link.
At 11:57 AM 2/15/02 +0100, Leif Jensen wrote:
>
> Hi there,
>
> I have been using psql's HTML option for quite some time to generate
>intranet tables from our corporate database, which works very nicely.
>
> I wonder if anyone has been extending this feature for better control of
>the output. At the moment I am piping output through several 'sed's to
>control table attributes like bgcolor, alignment, etc. It's very difficult
>to control individual columns, using colgroups, etc. this way. I would
>like some kind of additional options making it possible to add table
>attributes as well as making layout control easier.
>
> I have been thinking of having a look at the psql source for adding such
>features if they don't already exists, and I would welcome any suggestions
>in this respect !
>
> Greetings,
>
> Leif
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html
>
>