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

Import csv

From: Patrick Nelson <pnelson(at)neatech(dot)com>
To: "PostgreSQL List (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Import csv
Date: 2002-07-26 17:45:24
Message-ID: 4165C48DE9A0D211B6400800095C585F172DE4@WASHINGTON (view raw, whole thread or download thread mbox)
Lists: pgsql-general
I'm away from my PostgreSQL book (me SQL bible) and I'm faced with importing
csv (comma separated vales) file where I had setup all my scripts to tsv
(tab separated vales).  Yes I can use an editor, as such and change the
commas, but that's not the question.

How do I take a basic csv file and insert it into my table (named
dwnldstockanal)?  Just feel that this is something that I should know, but
me scratches me head.


pgsql-general by date

Next:From: terryDate: 2002-07-26 17:46:46
Subject: Re: Import csv
Previous:From: Stephan SzaboDate: 2002-07-26 17:42:43
Subject: Re: plpgsql: function throws error on second call!

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