Naming conventions for column names

From: Sachin Kotwal <kotsachin(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Naming conventions for column names
Date: 2017-11-06 10:33:25
Message-ID: CA+N_YAf3Bywmo_caFWXfFh6P20=T6CRkMexx+FSM=aEt6ikenQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

Is there any reason to keep column names as usesysid and senate instead of
usersysid and username ?

postgres=# select * from pg_stat_replication ;
pid | usesysid | usename | application_name | client_addr |
client_hostname | client_port | backend_start |
backend_xmin | stat
e | sent_location | write_location | flush_location | replay_location |
sync_priority | sync_state
------+----------+---------+------------------+---------------+-----------------+-------------+-------------------------------+--------------+-------
----+---------------+----------------+----------------+-----------------+---------------+------------
2297 | 24522 | replica | walreceiver | 192.168.16.53 |
| 49782 | 2017-08-15 00:45:43.256404-04 | 149384444 | stream
ing | 111/BD9D5328 | 111/BD9D5328 | 111/BD9D5328 | 111/BD9D52F0 |
0 | async
(1 row)

--

Thanks and Regards,
Sachin Kotwal

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sachin Kotwal 2017-11-06 10:36:40 Re: Naming conventions for column names
Previous Message Luca Ferrari 2017-11-06 09:36:06 xmin increasing within a transaction block?