Re: Database - Table browing problem. - Mailing list pgsql-cygwin

From Dave Page
Subject Re: Database - Table browing problem.
Date
Msg-id FED2B709E3270E4B903EB0175A49BCB1047374@dogbert.vale-housing.co.uk
Whole thread Raw
In response to Database - Table browing problem.  (Anil Jangam <anilj@indts.com>)
List pgsql-cygwin

> -----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

pgsql-cygwin by date:

Previous
From: Anil Jangam
Date:
Subject: Database - Table browing problem.
Next
From: Dave Page
Date:
Subject: Re: Database - Table browing problem.