Default value of column in information_schema

From: Юра Величко <velichko(dot)yuriy(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Default value of column in information_schema
Date: 2011-12-22 17:32:09
Message-ID: CAN=WvWu4YchvyW4hxjZ68XQEDSqqs4+qRk9k7s9ywDTSuQMPsQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello everyone!

I have a next question:
Is there some rule, that sets default value in
the information_schema.COLUMNS.column_default ?

Because for integer is - 777, and for character varying is - 'Hello
world'::character varying

I don't find description of this rule.

I need to know it, to clean up unused symbols from types like character
varying, and show it.

Thanks.

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2011-12-22 17:45:16 Re: How to create database with default system locale is set to et_EE.UTF-8
Previous Message Bèrto ëd Sèra 2011-12-22 17:15:36 Re: How to create database with default system locale is set to et_EE.UTF-8