| From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
|---|---|
| To: | Sachin Kotwal <kotsachin(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Naming conventions for column names |
| Date: | 2017-11-06 12:51:35 |
| Message-ID: | 4b129b1b-f5af-d007-30e4-9be9cacf175f@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | Postg토토 베이SQL |
On 11/6/17 05:36, Sachin Kotwal wrote:
> Is there any special reason to keep column names as usesysid
> and usename instead of usersysid and username in below system View?
The reason to *keep* them is compatibility. The reason they are like
that to start with is because that is the naming pattern used in the
system catalogs: 3 letters indicating the catalog, plus additional
letters or words. It is useful to use the same name in views such as
pg_stat_replication, so you can easily join different views and catalogs.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2017-11-06 12:53:30 | Re: xmin increasing within a transaction block? |
| Previous Message | Sachin Kotwal | 2017-11-06 10:36:40 | Re: Naming conventions for column names |