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

Re: Web pages tables over intranet

From: "Anthony E (dot) Greene" <agreene(at)pobox(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Web pages tables over intranet
Date: 2000-10-12 22:11:28
Message-ID: 20001012181128.B15674@cp5340 (view raw or flat)
Thread:
Lists: pgsql-novice
On Wed, 11 Oct 2000 17:53 Fernando M. Maresca wrote:
>There are some text-based DB wich are made with the data entered in a
>form in a web page. Now, I wish to move this text files to a a DB, but I
>don't know how I will do this.

If the fields are delimited (by tabs or commas, or some other single
character) then you can do it from within psql using the SQL copy command.

man l copy

-- 
Anthony E. Greene <agreene(at)pobox(dot)com> <http://www.pobox.com/~agreene/>
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26  C484 A42A 60DD 6C94 239D
Chat:  AOL/Yahoo: TonyG05    ICQ: 91183266
Linux. The choice of a GNU Generation. <http://www.linux.org/>


pgsql-novice by date

Next:From: Tony SimopoulosDate: 2000-10-12 22:12:59
Subject: Re: Importing Data into Postgresql from MS Access
Previous:From: David Huttleston JrDate: 2000-10-12 21:53:39
Subject: Re: Importing Data into Postgresql from MS Access

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