Re: [GENEAL] dynamically changing table - Mailing list pgsql-general

From Will Rutherdale (rutherw)
Subject Re: [GENEAL] dynamically changing table
Date
Msg-id 50A8E1F8D9122546A7F67134915EDB7A3B8E50@xmb-rtp-21a.amer.cisco.com
Whole thread Raw
In response to Re: [GENEAL] dynamically changing table  (A B <gentosaker@gmail.com>)
List pgsql-general
Is it possible that what you want is a lookup table with a string index,
i.e. attribute-value pairs?

If so, that would be represented as a hash in Perl, or a map in C++.  In
a database, you could design a very simple schema for it.

Or do you just have unclear requirements, as others have suggested?

-Will


-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of A B
Sent: 30 March 2009 14:51
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] [GENEAL] dynamically changing table

Well, the requirement is: keep a lot of data stored, don't loose any
of it, and you will not know what you will have to store (changing
number of fields and of different types)
But it is not all that bad, the fields will be integers, or text, or
floatingpoint numbers.

One  option is, put it in a db as a huge text  (or in textfiles, one
per object) and parse it when you need it. That might also work.


pgsql-general by date:

Previous
From: Dave Page
Date:
Subject: Re: PostgreSql with or without Plus?
Next
From: Jennifer Trey
Date:
Subject: Point me to latest JDBC for pgSQL (plus) standard server?