pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Popeanga Marian <pmarian@cnlo.ro>
To: Rado Petrik <r.p@szm.sk>
Cc: PostgreSQL-mailinglist <pgsql-sql@postgresql.org>
Subject: Re: Problem with Attribute.
Date: Tue, 06 May 2003 12:50:53 +0300
Message-ID: <3EB7857D.1070600@cnlo.ro> (raw)
References: <1052212666.551.29.camel@caj>

\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

view thread (4+ messages)  latest in thread

Message-ID: <3EB7857D.1070600@cnlo.ro>
Permalink:  ../3EB7857D.1070600@cnlo.ro/
Also on:    postgresql.org/message-id/3EB7857D.1070600@cnlo.ro

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: pmarian@cnlo.ro, r.p@szm.sk
  Subject: Re: Problem with Attribute.
  In-Reply-To: <3EB7857D.1070600@cnlo.ro>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox