Importing complete txt file with column names

From: robert kraus <rob_kra(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Importing complete txt file with column names
Date: 2002-07-02 22:29:06
Message-ID: 20020702222906.91349.qmail@web14303.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

hi,

I have multiple huge tab delimited txt files with >500
columns which I want to import, The name of the
columns is important, has to be the name of the column
in the table and is always very long. The copy command
seems to work only with predefined tables. How do I
import the tables with column names ?

thank you very much for your answer
robert

__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Karin Nila Huegele 2002-07-02 22:51:07 how to view table foreign keys/triggers?
Previous Message Tom Lane 2002-07-02 13:45:10 Re: Error Trapping -duplicate keys