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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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>
From | Date | Subject | |
---|---|---|---|
Next Message | Csanyi Pal | 2012-08-15 20:07:46 | Re: To get a Table or View like a Calendar with dates |
Previous Message | Tom Lane | 2012-08-13 14:23:29 | Re: Need help importing dump with bytea into db |