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