Re: One question about postgresql

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/

In response to

Browse pgsql-general by date

  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