Re: [GENERAL] How to find column type

2010-01-12 Thread Grzegorz Jaśkiewicz
take a look at information_schema.* table. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] How to find column type

2010-01-12 Thread Andrus
I'm looking for a way to create function which returns column type as single character: C = char/text/varchar, N=numeric, L=bool, others, U=unknown from expression in form 'tablename.columnname', where tablename if table from current search_path tables. search_path has two schemas. First