Hi ,
I have table picture_path.
1. Step one. Write query to psql.
power2=# select * from picture_path ;
retur:
id_path | p_path | count
---------+--------+--------
(0 rows)
2. Step two. Write query.
power2=# select count from picture_path;
return:
ERROR: Attribute 'count' not found
power2=#
Why ?
This is dump table picture_path.
CREATE TABLE "picture_path" (
"id_path" int4 DEFAULT nextval('"picture_path_id_path_seq"'::text)
NOT NULL,
"p_path" varchar(20) NOT NULL,
"count " int2 NOT NULL
);
Thanks.
-
Rado Petrik <r(dot)p(at)szm(dot)sk>