Re: Populating tables with data

From: Arthur van Dorp <arthur_vd(at)gmx(dot)net>
To: Kumar S <ps_postgres(at)yahoo(dot)com>
Cc: PostGreSQL <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Populating tables with data
Date: 2004-08-23 11:43:14
Message-ID: 4129D852.6050301@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi

> To make my question short, I have a (say) 3 tables. My data is in tab
> delimted text. I have to parse the data and direct the contents of
> each colums to columns in each table.
>
> How can I do this using Python? Any ideas please.

You don't even have to use Python. The COPY command should be enough:
http://www.postgresql.org/docs/7.4/interactive/sql-copy.html

Arthur

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2004-08-23 11:57:25 Re: Populating tables with data
Previous Message Kumar S 2004-08-23 11:37:15 Re: Populating tables with data