Skip site navigation (1) Skip section navigation (2)

Re: how to get desired html format output?

From: Michael Wood <esiotrot(at)gmail(dot)com>
To: Anne Wainwright <anotheranne(at)fables(dot)co(dot)za>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: how to get desired html format output?
Date: 2012-08-14 06:25:05
Message-ID: CAP6d-HW3k_SuGwSGWALeAC7fihFLFbMQr9jvdRZaE5TAMYKXWg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi

On 9 August 2012 11:47, Anne Wainwright <anotheranne(at)fables(dot)co(dot)za> wrote:
> On Thu, Aug 09, 2012 at 02:57:16PM +0530, Jayadevan M wrote:
>> Hello,
>>
>> > 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?
>>
>> 1) Turn on the HTML output option -
>> newgendb=# \H
>> Output format is html.
>>
>> 2) Direct the output to a file
>>
>> newgendb=# \o myfile.html
>>
>> 3) Execute the select
>>
>> 4) Turn off output
>> newgendb=# \o
>>
>> Regards,
>> Jayadevan
>>
> I know that this will make a table output but it isn't going to do
> all the fancy formatting that I need like
>
> <b>author</b> ... <i>condition</i> ... <fontt align=right>price</font>
>
> so my question perhaps needs to be rephrased as 'how do I get specific
> html text formatting commands in the html output?'
>
> back to perl maybe? not an issue but being able to do something from
> within postgresql would save that extra step.

One other option to investigate would be to use CSS to set the fonts,
text alignment, etc.

I haven't checked the generated HTML to see how feasible this is, though.

-- 
Michael Wood <esiotrot(at)gmail(dot)com>


In response to

pgsql-novice by date

Next:From: Csanyi PalDate: 2012-08-15 20:07:46
Subject: Re: To get a Table or View like a Calendar with dates
Previous:From: Tom LaneDate: 2012-08-13 14:23:29
Subject: Re: Need help importing dump with bytea into db

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group