Re: Database - Table browing problem.

> -----Original Message-----
> From: Anil Jangam [mailto:anilj(at)indts(dot)com]
> Sent: 14 December 2001 09:41
> To: 'pgsql-cygwin(at)postgresql(dot)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