Re: Question

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Hrishikesh Deshmukh <hdeshmuk(at)gmail(dot)com>
Cc: Postgresql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Question
Date: 2006-02-08 06:41:04
Message-ID: 20060208064104.GA20477@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Feb 06, 2006 at 10:54:49 -0500,
Hrishikesh Deshmukh <hdeshmuk(at)gmail(dot)com> wrote:
> Hi All,
>
> I am trying to create a simpel table to handle geneId and productId but the
> data file which i want to read in has for some genes more than one productId
> ex:
> GeneId | ProID1 /// ProID2 /// ProID3
>
> Now how does one input the same information without having GeneId listed in
> the table more than once if possible?!!!
> If i read-in the info. just as it appears in the file then will the querying
> be a big problem since there is more than one ProID/ per gene and not to
> mention '///' characters!

Write a filter which reads your file and writes something suitable for copy.
In fact if you use perl, you could have the script feed stuff to copy as
it is being read in.

In response to

  • Question at 2006-02-06 15:54:49 from Hrishikesh Deshmukh

Browse pgsql-general by date

  From Date Subject
Next Message Sergey Karin 2006-02-08 07:42:41 alter superuser...
Previous Message Rob Newton 2006-02-08 06:22:30 futex lockup?