> fine). PG returns: ERROR: Relation "_con" does not exist > > This is my query: > > SELECT > _CON.con_id, Please make sure you get the quoting right regarding table names. PostgreSQL will fold _CON into _con unless quoted "_CON". So, it may be that you created the table with quotes ("_CON"). Now, in your query you don't use quotes and thusly it is looking for a _con table. The simple rule of thumb is to either always or never use quotes.
HTH, Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match