Re: how can I get the length of columns of a table by system tables/views
| От | Raghavendra |
|---|---|
| Тема | Re: how can I get the length of columns of a table by system tables/views |
| Дата | |
| Msg-id | CA+h6AhhcnXmvDPXk2XzqRY8W7J+WKmALSen_rMcXT_38=P3_Sw@mail.gmail.com обсуждение исходный текст |
| Ответ на | how can I get the length of columns of a table by system tables/views (shuaixf <shuaixf@gmail.com>) |
| Ответы |
Re: how can I get the length of columns of a table by system tables/views
|
| Список | pgsql-admin |
For example:
CREATE TABLE tb(name varchar(32));
You can get this with System functions.
select pg_column_size(name) from tb;
---
Regards,
Raghavendra
EnterpriseDB Corporation
On Wed, Sep 7, 2011 at 8:50 PM, shuaixf <shuaixf@gmail.com> wrote:
According to pg_class, pg_attribute, pg_type, I can get the tablename,
column name, column type
however, how to get the length of columns of a table by system tables/views?
Thanks!
--
View this message in context: http://postgresql.1045698.n5.nabble.com/how-can-I-get-the-length-of-columns-of-a-table-by-system-tables-views-tp4778911p4778911.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
В списке pgsql-admin по дате отправления: