Re: One question about postgresql

Поиск
Список
Период
Сортировка
От Andrew Gould
Тема Re: One question about postgresql
Дата
Msg-id 20010605221929.32159.qmail@web13406.mail.yahoo.com
обсуждение исходный текст
Ответ на One question about postgresql  (S R <syr_22@yahoo.com>)
Список 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@yahoo.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 direcci�n 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/

В списке pgsql-general по дате отправления:

Предыдущее
От: Alex Pilosov
Дата:
Сообщение: optimizer hints?
Следующее
От: "Thalis A. Kalfigopoulos"
Дата:
Сообщение: Re: PostgreSQL and TPC benchmarks