#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2000
    Location
    vancouver, bc
    Posts
    145
    Rep Power
    15

    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
    I know nothing
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 1999
    Location
    New York City
    Posts
    69
    Rep Power
    16
    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!!!
    -------------------------
    The new search engine in town:
    http://www.w3matter.com

IMN logo majestic logo threadwatch logo seochat tools logo