| From: | "Brett W(dot) McCoy" <bmccoy(at)lan2wan(dot)com> |
|---|---|
| To: | kheflin <kheflin(at)shreve(dot)net> |
| Cc: | pgsql-general(at)hub(dot)org |
| Subject: | Re: [GENERAL] Importing delimited files |
| Date: | 1998-06-22 15:40:47 |
| Message-ID: | Pine.BSI.3.91.980622113845.27453B-100000@access1.lan2wan.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 22 Jun 1998, kheflin wrote:
> I've usually imported any delimited text files into my PostgreSQL
> databases using "PGACCESS" which has worked great for me. Our System
> Admin here is wanting to import a delimited text file into a postgresql
> database using the psql command line...
>
> any suggestions?
Use the SQL command COPY for importing a delimited fileinto a tabl. You
can also use the psql command \copy, but it isn't as flexible. Take a
look at the online help in psql for the exact syntax of both commands.
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
"The Number of UNIX installations has grown to 10, with more expected."
-- The UNIX Programmer's Manual, 2nd Edition, June, 1972
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Good | 1998-06-22 16:07:36 | Re: [GENERAL] Importing delimited files |
| Previous Message | kheflin | 1998-06-22 15:03:58 | Importing delimited files |