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@acsinc-nj.com> wrote in message
news:NmGs7.891$jW2.56920@typhoon1.gnilink.net...
> 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@ascinc-nj.com
>
>
>
