Uploading files to Postgresql
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
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
Show quoted text
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