B
B
beduin012016-04-06 16:59:40
PostgreSQL
beduin01, 2016-04-06 16:59:40

Where am I wrong in the request?

Prompt, in what not so can be with request. But I can't find the error:

insert into "USERS"(userblob) values (pg_read_file('D:/foo/img.png')::bytea) WHERE id>1;

Swears on the WHERE condition. I tried putting "id" in quotes, but it didn't work...

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Melkij, 2016-04-06
@melkij

Here is the syntax for insert: www.postgresql.org/docs/9.4/static/sql-insert.html
Find where here.
What are you trying to do?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question