Re: Naming conventions for column names

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(at)gmail(dot)com> 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