From: | Andrew Gould <andrewgould(at)yahoo(dot)com> |
---|---|
To: | S R <syr_22(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: One question about postgresql |
Date: | 2001-06-05 22:19:29 |
Message-ID: | 20010605221929.32159.qmail@web13406.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Yes. PostgreSQL has a COPY command that you can use
to import data from a delimited text file. You will
have to create the table prior to using the copy
command.
The text file should have only one delimiter. Many
text files use quotes to enclose text values in
addition to having a delimiter between data fields.
PostgreSQL doesn't handle this situation. If you have
problems with this part, let me know. There are ways
to fix this problem.
Best of luck,
Andrew Gould
--- S R <syr_22(at)yahoo(dot)com> wrote:
> Hello, please, I need urgent to know if postgresql
> has
> something to obtein information of a file,in other
> words if postgresql can read to the file and then
> insert the values into a table.
>
> Thank you for your attention.
>
>
> Sandra
>
>
_________________________________________________________
> Do You Yahoo!?
> Obtenga su direccin de correo-e gratis @yahoo.com
> en http://correo.espanol.yahoo.com
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Barnard | 2001-06-05 22:19:30 | Re: [ADMIN] Limiting simultaneous connections |
Previous Message | Stephan Szabo | 2001-06-05 22:14:47 | RE: Limiting simultaneous connections |