Trying to run this query:

UPDATE tblMonitor SET Make = 'Phillips' WHERE Make = 'Ph*';

get the error message that " Error: relation "tblMonitor" does not exist"

yet when I look at the relations it is there.

List of relations
Schema | Name | Type | Owner
--------+------------------+------+------
public | UpdatePC's | table | bob
public | lkpBuildings | table | bob
public | lkpCPU | table | bob
........

public | tblWorkstation | table | bob
(23 rows)


Bob




---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

On Tue, 4 May 2004, Robert Morgan wrote:

Does it really look exactly like that or does it show as tblmonitor in the
error message?

Well, this doesn't show tblMonitor, but given tblWorkstation, this
probably means you created the table with double quotes around the name
(or your interface did) which means you should use double quotes to refer
to it, so something like:
update "tblMonitor" ...

You may need to double quote the column names if the same is true there.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org