On Feb 15, 2008, at 4:49 AM, [EMAIL PROTECTED] wrote:
Hi all,
I have a large sdf file with many records of molecules and associated
data items and I want to save them in a PostgreSQL database. There are
about less than 40 data items for every molecule(the names of the data
items fore each mole
If you can select stable structure (common columns) and additional columns
than you can :
1. Use base class (table) with common columns + inherited tables with their
own additional columns
2. We use contrib/hstore as a storage for semistructured data - we store
additional columns as a key->
On Friday 15. February 2008, [EMAIL PROTECTED] wrote:
>Hi all,
>
>I have a large sdf file with many records of molecules and associated
>data items and I want to save them in a PostgreSQL database. There are
>about less than 40 data items for every molecule(the names of the data
>items fore each mo
Hi all,
I have a large sdf file with many records of molecules and associated
data items and I want to save them in a PostgreSQL database. There are
about less than 40 data items for every molecule(the names of the data
items fore each molecule are the same, but values differ). The number
of mol
