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