Does PostgreSQL have an equivalent function for determining column metadata? Reference: [SQL_VARIANT_PROPERTY][1] [pg_typeof()][2] appears to be close, but it does not show the precision and scale. Looking up the type in [pg_type][3] only shows the generic type info, not the column specific, e.g. [SQL Fiddle][4]. [1]: http://msdn.microsoft.com/en-us/library/ms178550.aspx [2]: http://www.postgresql.org/docs/current/interactive/functions-info.html#FUNCTIONS-INFO-CATALOG-TABLE [3]: http://www.postgresql.org/docs/current/interactive/catalog-pg-type.html [4]: http://www.sqlfiddle.com/#!1/032b5/3/0