Re: Uploading files to Postgresql

Hi Liam,
Have a look at the COPY command, it should do what you want.
Do you know about the online book devoted to postgresql? It's a great
supplement to the manual, it can be found at:
http://www.ca.postgresql.org/docs/aw_pgsql_book/node3.html

all the best,
adam

Liam DeMasi <ldemasi(at)acsinc-nj(dot)com> wrote in message
news:NmGs7(dot)891$jW2(dot)56920(at)typhoon1(dot)gnilink(dot)net(dot)(dot)(dot)
> I am new to databases and am trying to find out if it is possible to
upload
> a file of records that are deliminated by a character such as | to
> Postgresql.
> I have a file that has about 400,000 records in it and I would really like
> to not have to enter all these in individually.
>
> Thank you
> my email is ldemasi(at)ascinc-nj(dot)com
>
>
>