Re: TODO: Add pg_get_acldef(), pg_get_typedefault(), pg_get_attrdef(),

Tom Lane wrote:
> "Joshua D. Drake" <jd@commandprompt.com> writes:
>>> If all you want is column, datatype, why not just use info_schema, or
>>> newsysviews? Or even the base catalogs?
> 
>> Where do I look in the info_schema? How do I know exactly what I need? 
>> What is newsysviews?
> 
> Exactly the same arguments can be made against any new functions we
> invent.  OTOH, I do not think these arguments apply to selecting from
> information_schema; that is SQL standard, and if someone doesn't know
> what to do with it I don't think it's our fault.

I am not blaming us :).

I am just saying that certain functions can make life easier.

What is easier?

test=# select column_name, data_type from columns where table_schema != 
'pg_catalog' and table_name = 'email'; column_name | data_type
-------------+----------- score       | real


Or:

select pg_get_user_tabledesc(email);

This is the basis of my argument. I don't really have anything to add.

:)

Joshua D. Drake






> 
>             regards, tom lane
> 


-- 
            === The PostgreSQL Company: Command Prompt, Inc. ===      Sales/Support: +1.503.667.4564 || 24x7/Emergency:
+1.800.492.2240     Providing the most comprehensive  PostgreSQL solutions since 1997
http://www.commandprompt.com/