Re: pg_dump and ANSI types (TODO item)

Philip Warner writes:

> Just looking at the TODO list for other pg_dump related items, and saw:
> 
>     add pg_dump option to dump type names as standard ANSI types 
> 
> Tow questions:
> 
> Do we already have a function to represent PG types as ANSI standard types?

format_type(pg_type.oid, pg_attribute.atttypmod)

> How should types that are not in the standard be represented?

Whatever format_type gives you.

I wrote format_type for exactly this purpose a few weeks ago, but I
figured I let you get the glory for making pg_dump use it. :-) psql uses
it as well.

Note: IMO it should not be an *option* to use format_type, it should
always be used. It's nice for encapsulation on the programming side and
there's no reason for using any other type names.


-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden