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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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/>

Browse pgsql-novice by date

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