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
PROTECTED]
Fax: (416) 441-9085
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Oliver Elphick
> Sent: Wednesday, November 19, 2003 6:22 PM
> To: Brian H Mayo
> Cc: PostgreSQL general list
> Subject: Re: [GENERAL] A newbie question
>
&
On Wed, 2003-11-19 at 02:43, Brian H Mayo wrote:
> I am a newbie to PostgreSQL. I added plpgsql to the database and
> wrote a function in the plpgsql language. How do I execute it?
>
> I read all of the manuals but I cannot seem to figure it out. I
> pulled up the pgadmin III SQL and tried diffe
I am a newbie to PostgreSQL. I added plpgsql to the database and
wrote a function in the plpgsql language.
How do I execute it?
I read all of the manuals but I cannot seem to figure it
out. I pulled up the pgadmin III
SQL and tried different combinations to run the function. I tried PE
