Re: Problem with Attribute.

\d picture_path in pgsql what returns ?

Rado Petrik wrote:

>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>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>message can get through to the mailing list cleanly
>
>
>

--
Popeanga Marian
DBA Oracle
CNLO Romania