John Fabiani <jfabiani(at)yolo(dot)com> writes:
> Thanks but in the doc's it uses the term 'columnname'. The real issue is the
> tablename.columnname is supported in MySQL and I'm trying to support Postgres
> and MySQL with a single code routine.
If you want portable code, I suggest conforming to the SQL-standard
syntax. The table name is disallowed there according to the spec.
regards, tom lane