Re: [GENERAL] Naming conventions for column names - Mailing list 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