Re: type of a field

ameen eetemadi schrieb:

> I want to know the type of a field in a table how can I khow it ?

pg_fieldtype()

or something like

SELECT a.attname, format_type(a.atttypid, a.atttypmod)
FROM pg_class c, pg_attribute a
WHERE c.relname = '$tablename'
AND a.attnum > 0 AND a.attrelid = c.oid
ORDER BY a.attnum;

?

Bye,
Knut Sübert