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

-- 
Popeanga Marian
DBA Oracle
CNLO Romania