Re: PL/PGSQL and external (flat ASCII) files - Urgent ... :)

Crhis,

> Thanks ;). I'm new to PostGreSQL and to PHP and to SQL - I have done
> Progress RDBMS/4GL for the last 12 years and it absolutely spoils
> you. But
> in the last 2 weeks, I have hammered out an application (you can have
> a look
> at http://chill-025.bbnow.net, use user demo and password demo).

Hey, if you're fond of 4GL, somebody's grafted 4GL as a trusted language
for PostgreSQL. I'll send the web page when I can find it ...

> To which I copy (psql copy statement) two files. One contains s =
> entity
> code and type = 'entity', the others has a long string of data and
> NULL in
> the type.

Glad you found something that works.

> I can not go the perl or TCL route since I do this all in my spare
> time. A
> friend of mine needs this application for his business and we have
> plans to
> sell it on, once we have it completed. So, the only hacker who plays
> with
> this right now, is me, and me has no clue about Perl or TCL and
> although me
> would like to learn these languages one day, this applications need
> to be
> completed no later than this coming weekend. The pl/pgsql part is
> just a
> small portion of the whole thing. I still need to figure out a way to
> export
> data which I calculate to let gnuplot create pretty pictures for me.
>
> And today is the first day, I try pl/pgsql ... Today, the data import
> program must get finished ... Do I need to say more?

So ... this friend saved your life recently?

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco