programmtically...(aren't you using a database
to avoid flatfiles altogether? :-)
hope that helps,
robby
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Chris Ruprecht
Sent: Tuesday, July 17, 2001 3:29 PM
To: p-sql
Subject: [SQL] PL/PGSQL and external (flat
You can probably try to make a c extension that does open/close.
On 17 Jul 2001 15:28:36 -0500, Chris Ruprecht wrote:
Hi all,
I need to know how I can access a flat file from within a PL/PGSQL script.
I have an Oracle PL/SQL book here and they refer to FOPEN(...), FCLOSE(...)
but these
Chris Ruprecht [EMAIL PROTECTED] writes:
I need to know how I can access a flat file from within a PL/PGSQL script.
You can't --- and you should ask yourself hard questions about why your
system design needs that, or whether the data in question shouldn't be
inside the database to begin with.
Hi Tom,
If life was easy, everything would just come in the format I'd like it. But
since it isn't, I need to create records like this one:
cdate| ctime | countrycode | areacodex | success | carrier |
duration| phonenumber | areacode | pseq | loadno | frline | entity |
loaddate |
Chris Ruprecht [EMAIL PROTECTED] writes:
If life was easy, everything would just come in the format I'd like it. But
since it isn't, I need to create records like this one:
...
From an input file where the records looks like this one:
If it's just a data import issue, why do you want to do
Chris,
Hmmph. People are in a bad mood this week; obviously few other people
on the list have had to write applications for the banking industry,
which trades everything in flat files. Give Chris a break!
From an input file where the records looks like this one:
020-13 016-05 07-15-2001
Hi Josh,
on 07/17/2001 18:31, Josh Berkus at [EMAIL PROTECTED] wrote:
Chris,
Hmmph. People are in a bad mood this week; obviously few other people
on the list have had to write applications for the banking industry,
which trades everything in flat files. Give Chris a break!
Thanks
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