Re: html to postgres... - Mailing list pgsql-general

From Jose Manuel Lorenzo Lopez
Subject Re: html to postgres...
Date
Msg-id 200107161536.f6GFaOF36634@cmplant.conti.de
Whole thread Raw
In response to html to postgres...  (Tony Grant <tony@animaproductions.com>)
List pgsql-general
16.07.2001 16:48:53, Tony Grant <tony@animaproductions.com> wrote:

>Hello,
>
>I have several hundred HTML (!) pages that need to be converted to a
>format that in turn can be imported into PostgreSQL. They are all built
>on a very similar grid.
>
>Any thoughts?

Hello Tony,

I guess you want to insert the data of tables included in your HTML
Pages, am I right???

If so, may be you want to create a Shell-Script (Perl ???) that reads the
rows of your tables in the HTML-Pages using the HTML  tags
<th></th>  <td></th>as field separator.

You also can convert the HTML-pages first in human readable ascii - tables :)
and than read this output with a Script (Again Perl ???). The tools to do
this is 'html2text'.

Best Regards  / Mit freundlichen Gruß / Un saludo

José Manuel Lorenzo López





pgsql-general by date:

Previous
From: markMLl.pgsql-general@telemetry.co.uk
Date:
Subject: Re: html to postgres...
Next
From: "Mitch Vincent"
Date:
Subject: Re: db & table names