Re: Question - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Question
Date
Msg-id 20060208064104.GA20477@wolff.to
Whole thread Raw
In response to Question  (Hrishikesh Deshmukh <hdeshmuk@gmail.com>)
List pgsql-general
On Mon, Feb 06, 2006 at 10:54:49 -0500,
  Hrishikesh Deshmukh <hdeshmuk@gmail.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.

pgsql-general by date:

Previous
From: Rob Newton
Date:
Subject: futex lockup?
Next
From: Sergey Karin
Date:
Subject: alter superuser...