Skip site navigation (1) Skip section navigation (2)

Importing a CSV file to a table on Postgres

From: "Oliveiros Cristina" <oliveiros(dot)cristina(at)marktest(dot)pt>
To: "Novice Postgresql-list" <pgsql-novice(at)postgresql(dot)org>
Subject: Importing a CSV file to a table on Postgres
Date: 2007-05-04 11:48:24
Message-ID: 002e01c78e42$1f5d4360$ec5a3d0a@marktestcr.marktest.pt (view raw or flat)
Thread:
Lists: pgsql-novice
Hello, list.

I have a CSV file with two values/row and I would like to import it into a table who has two columns as well.

Is there an easy and expedited way to do this with Postgres administration tool(PgAdmin)? I can do a program that parses the file and INSERTs the values on table, but I suspect that there is an easy way and that it is not worth the effort.

Best,
Oliveiros

In response to

Responses

pgsql-novice by date

Next:From: A. KretschmerDate: 2007-05-04 12:24:36
Subject: Re: Importing a CSV file to a table on Postgres
Previous:From: Jasbinder Singh BaliDate: 2007-05-02 21:19:02
Subject: Re: What is this thing that is called a "Data Dictionary?"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group