Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    43

    Unanswered: help with COPY over network?

    Hello,

    I am wondering if it is possible to use the COPY function to load data from a text file on a Windows network drive to my PostgreSQL database running on Linux.

    Thanks,
    Steve.

  2. #2
    Join Date
    Apr 2003
    Location
    Tunisia
    Posts
    192

    FTp it !

    The first thing you should do is to upload that file via FTp or SSh to the server then, you'll be able to copy it, unless you map a windows Network drive under linux then call it to copy. if you are willing to dump a table, you can use one of the many postgresql GUI tools under windows http://www.pgadmin.org or http://www.dbtools.com.br
    Open up
    Take a look to my Blog http://www.rundom.com/karim2k

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •