Re: [GENERAL] Naming conventions for column names

Поиск
Список
Период
Сортировка
От Sachin Kotwal
Тема Re: [GENERAL] Naming conventions for column names
Дата
Msg-id CA+N_YAcazMuWH-cUT_cKMxFP7rAbsjaFOFGs_KLDKrNbD-k9yw@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] Naming conventions for column names  (Sachin Kotwal <kotsachin@gmail.com>)
Ответы Re: [GENERAL] Naming conventions for column names  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-general
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@gmail.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

В списке pgsql-general по дате отправления:

Предыдущее
От: Sachin Kotwal
Дата:
Сообщение: [GENERAL] Naming conventions for column names
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: [GENERAL] Naming conventions for column names