Re: Naming conventions for column names

[Sachin Kotwal <kotsachin@xxxxxxxxx>]

Hi All,

Correcting my words.

Is there any special reason to keep column names as usesysid and usename instead of usersysid and username in below system View?

On Mon, Nov 6, 2017 at 4:03 PM, Sachin Kotwal <kotsachin@xxxxxxxxx> wrote:

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

--

Thanks and Regards,

Sachin Kotwal