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
|
| Список | 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 | state | 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 | streaming | 111/BD9D5328 | 111/BD9D5328 | 111/BD9D5328 | 111/BD9D52F0 | 0 | async(1 row)--Thanks and Regards,Sachin Kotwal
Sachin Kotwal
В списке pgsql-general по дате отправления: