The example is below:
On Thu, 12 Oct 2000, Jean-Christophe Boggio wrote:
> Hi Indraneel,
>
> IM> I'm converting a complex flatfile where records are arranged serially.
> IM> some fields are as 'n' times repeating blocks of multiple lines. Some
> IM> subfields within these are also 'n' time repe
Thanks, this is what I'm currently using and want to change from. This
table is taking a long time to insert data into and to extract. My
smallest table of this sort has 68000 rows. In comparison arrays are 10
times faster but lack the required tools to work with (especially for
multidimensional a
You may want to think about creating your table like this (for example):
CREATE TABLE data
(
key text,
field_type char,
value text
);
CREATE UNIQUE INDEX data_key ON data(key, field_type, value);
So this way each "record" takes up several rows in the table, and each "fie
Hi,
I'm not sure if the subject line has been proper. I have this following
problem which I hope PostgreSQL can handle.
I'm converting a complex flatfile where records are arranged serially.
some fields are as 'n' times repeating blocks of multiple lines. Some
subfields within these are also 'n'
