Re: Database - Table browing problem.

> -----Original Message-----
> From: Anil Jangam [mailto:anilj@indts.com]
> Sent: 14 December 2001 09:41
> To: 'pgsql-cygwin@postgresql.org'
> Subject: [CYGWIN] Database - Table browing problem.
> Importance: High
>
>
> Hi,
>
> I have successfully created a user (createuser command) and
> the database (using createdb command). Now when I create a
> table either by using the create table commnd or through
> pgAdmin interface, its creating the table succesfully.. but
> when I try to see the contents of the table i.e. select *
> from <table name>; it gives the error message,
>
>         "ERROR:  Relation '<table name>' does not exist
>
> What could be the problem?? I couldn't resolve it.

pgAdmin will allow you to create a table with capital letters in the name.
If you have done this, then make sure you surround the name in quotes in
your select query e.g.

SELECT * FROM "MixedCaseName"

Regards, Dave