pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
ERROR:  relation "mytable" does not exist
2+ messages / 2 participants
[nested] [flat]

* ERROR:  relation "mytable" does not exist
@ 2005-05-04 12:54 Peter Schonefeld <peter.schonefeld@bigpond.com>
  2005-05-07 10:43 ` Re: ERROR:  relation "mytable" does not exist Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 1 reply; 2+ messages in thread

From: Peter Schonefeld @ 2005-05-04 12:54 UTC (permalink / raw)
  To: pgsql-admin

Hi, I'm a postgres newbie trying to convert a small SQL Server database to
postgres 8.0 .

A typical table that i've created looks like this...

CREATE TABLE "Country"
(
  "Id" int2 NOT NULL,
  "Name" varchar(50) NOT NULL,
  CONSTRAINT "PK_Country" PRIMARY KEY ("Id")
)
WITHOUT OIDS;
ALTER TABLE "Country" OWNER TO postgres;
COMMENT ON TABLE "Country" IS 'listing of countries';

If i try SELECT * FROM Country, i get 'ERROR: relation "country" does not
exist.

Also, I'm looking for a good function reference.

Any help would be appreciated.

Regards
Pete





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: ERROR:  relation "mytable" does not exist
  2005-05-04 12:54 ERROR:  relation "mytable" does not exist Peter Schonefeld <peter.schonefeld@bigpond.com>
@ 2005-05-07 10:43 ` Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Eisentraut @ 2005-05-07 10:43 UTC (permalink / raw)
  To: Peter Schonefeld <peter.schonefeld@bigpond.com>; +Cc: pgsql-admin

Peter Schonefeld wrote:
> CREATE TABLE "Country"

> If i try SELECT * FROM Country, i get 'ERROR: relation "country" does
> not exist.

If you write "Country" once, then you might write "Country", not 
Country, all the time, because otherwise the name will be converted to 
lower case.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-05-07 10:43 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-05-04 12:54 ERROR:  relation "mytable" does not exist Peter Schonefeld <peter.schonefeld@bigpond.com>
2005-05-07 10:43 ` Peter Eisentraut <peter_e@gmx.net>

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