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.
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? |