Re: Populating tables with data - Mailing list pgsql-novice

From Arthur van Dorp
Subject Re: Populating tables with data
Date
Msg-id 4129D852.6050301@gmx.net
Whole thread Raw
In response to Re: Populating tables with data  (Kumar S <ps_postgres@yahoo.com>)
Responses Re: Populating tables with data
List 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

pgsql-novice by date:

Previous
From: Kumar S
Date:
Subject: Re: Populating tables with data
Next
From: "Sean Davis"
Date:
Subject: Re: Populating tables with data