Postgres Pro
Downloads
Home   >   mailing lists

Default value of column in information_schema - Mailing list pgsql-general

From Юра Величко
Subject Default value of column in information_schema
Date
Msg-id CAN=WvWu4YchvyW4hxjZ68XQEDSqqs4+qRk9k7s9ywDTSuQMPsQ@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Bèrto ëd Sèra
Date:
Subject: Re: How to create database with default system locale is set to et_EE.UTF-8
Next
From: "Andrus"
Date:
Subject: Re: How to create database with default system locale is set to et_EE.UTF-8