Helpful Information
 
 
Category: PostgreSQL Help
can postgres do bulk uploading via file?

hi,

I want to bulk upload a bunch of data using file into Postgres. is that possible? and what file is better? tab-delimited or comma delimitted? i would think comma..

the file would come from Excel.

what would be the command to do this?

thanks
edwin

Yes, it is possible after all :-)

pg_load will do the trick.

Lookup the command at the postgresql.org site.

The manual is your friend!!!










privacy (GDPR)