Hi,
I don't think I was clear enough.
I know about using the AS keyword, that is not the problem.
The query in issue is:
select true,78,'Here is a value' as stringfield, testname from tbltest
Is returning the string as TYPE Unknown, not the column name. The
column name comes back as stringfield because of the AS keyword.
You can see the type in tools such as PG Admin etc
Thanks,
Tony