I'm trying to import in a table with columns (name, x, y, geom) like this:
INSERT INTO public.table (name, x, y, geom) VALUES ('name', X, Y, ST_GEOMFROMTEXT('POINT(X,Y)', SRC))
But I'm obtaining this error:
ERROR: parse error - invalid geometry SQL state: XX000
X, Y and SRC are integers. I've wrote X and Y as generic.
What's going on?