Postgres Pro
Downloads
Home   >   mailing lists

Import csv file into multiple tables in Postgres - Mailing list pgsql-novice

From Deepblues
Subject Import csv file into multiple tables in Postgres
Date
Msg-id bd6cfb9e05022711151a8e6a88@mail.gmail.com
Whole thread Raw
Responses Re: Import csv file into multiple tables in Postgres  (Andrew Hammond <ahammond@ca.afilias.info>)
List pgsql-novice
Tree view 
Hi,

   Is it possible to import data from a csv file into multiple tables
in postgresql database.
suppose if I have 2 tables students and departments. And my csv file
contains data for both the tables. Can I import this data into the two
tables.

Is there any perl script available to do this.

Help me out with this !!

thanks,
Deepblues

pgsql-novice by date:

Previous
From: Wolfgang Keller
Date:
Subject: PL/Pgsql or PL/Python?
Next
From: "Mark Quinn"
Date:
Subject: Warning: pg_exec() query failed: ERROR: Attribute "admin" not found