pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Uploading files to Postgresql
2+ messages / 2 participants
[nested] [flat]

* Uploading files to Postgresql
@ 2001-09-27 14:05  Liam DeMasi <ldemasi@acsinc-nj.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Liam DeMasi @ 2001-09-27 14:05 UTC (permalink / raw)
  To: pgsql-docs

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






^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Uploading files to Postgresql
@ 2001-09-28 03:30  Adam Fisher <black@cia.com.au>
  parent: Liam DeMasi <ldemasi@acsinc-nj.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Adam Fisher @ 2001-09-28 03:30 UTC (permalink / raw)
  To: pgsql-docs

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
>
>
>





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2001-09-28 03:30 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-09-27 14:05 Uploading files to Postgresql Liam DeMasi <ldemasi@acsinc-nj.com>
2001-09-28 03:30 ` Adam Fisher <black@cia.com.au>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox