Thread: One question about postgresql

One question about postgresql

From
S R
Date:
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

Re: One question about postgresql

From
Andrew Gould
Date:
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/