Re: Problems Importing table to pgadmin

John R Pierce <pierce@xxxxxxxxxxxx> · Wed, 7 Dec 2016 15:47:10 -0800



    On 12/7/2016 3:28 PM, David G. Johnston
      wrote:

    
      On the second
        image you are using double-quotes to delimit a string literal. 
        This is wrong.  PostgreSQL always uses single quotes to indicate
        literal string value double quotes are reserved for object
        identifiers (table names, column names, etc).
      

    AND, COPY table from filename only works at the *SERVER* level,
      not at the user level, and can only be done by a database
      superuser.    the database server likely has no right to access
      files on your desktop.  In the psql shell, you can use \copy to do
      this, that actually does a COPY table FROM stdin;  then the psql
      client reads your file and pipes it to that COPY command, so the
      file is read by the client, and not the server.
    

    -- 
john r pierce, recycling bits in santa cruz