Postgres Pro
Downloads
Home   >   mailing lists

Importing a CSV file to a table on Postgres - Mailing list pgsql-novice

From Oliveiros Cristina
Subject Importing a CSV file to a table on Postgres
Date
Msg-id 002e01c78e42$1f5d4360$ec5a3d0a@marktestcr.marktest.pt
Whole thread Raw
In response to Re: What is this thing that is called a "Data Dictionary?"  ("Jim Stalewski" <JStalewski@VisaLighting.com>)
Responses Re: Importing a CSV file to a table on Postgres  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: "Jim Stalewski"
Date:
Subject: Re: What is this thing that is called a "Data Dictionary?"
Next
From: "A. Kretschmer"
Date:
Subject: Re: Importing a CSV file to a table on Postgres