> -----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
> 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"
pgsql-cygwin by date
|Next:||From: Dave Page||Date: 2001-12-14 10:38:01|
|Subject: Re: Database - Table browing problem.|
|Previous:||From: Anil Jangam||Date: 2001-12-14 09:40:42|
|Subject: Database - Table browing problem.|