Re: Problems Importing table to pgadmin

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