Re: [ADMIN] Notes or comments on columns in a table

2013-02-14 Thread Craig James
On Thu, Feb 14, 2013 at 11:09 AM, Campbell, Lance wrote: > PostgreSQL 9.2 > > When creating a table or altering a column of a table, is there a way to > add notes on a column? > > ** ** > > If not: > > I have a new enhancement request. When creating a table or altering a > column, it

Re: [ADMIN] Notes or comments on columns in a table

2013-02-14 Thread Thomas Kellerer
Campbell, Lance wrote on 14.02.2013 20:09: PostgreSQL 9.2 When creating a table or altering a column of a table, is there a way to add notes on a column? comment on table foo is 'the foo table'; comment on column foo.bar is 'the bar column'; http://www.postgresql.org/docs/current/static/sql-

[ADMIN] Notes or comments on columns in a table

2013-02-14 Thread Campbell, Lance
PostgreSQL 9.2 When creating a table or altering a column of a table, is there a way to add notes on a column? If not: I have a new enhancement request. When creating a table or altering a column, it would be nice if a user could add "comments" or "notes" to a column. This note would only app

Re: [ADMIN] viewing the slaves which are connected to a master in streaming replication

2013-02-14 Thread Lonni J Friedman
On Thu, Feb 14, 2013 at 10:05 AM, Raghavendra wrote: > > On Thu, Feb 14, 2013 at 11:30 PM, Lonni J Friedman > wrote: >> >> I've got a postgres-9.2.x cluster, doing streaming replication to >> several hot standby servers. I'd like to be able to query the master >> to see the hostname or IP addres

Re: [ADMIN] viewing the slaves which are connected to a master in streaming replication

2013-02-14 Thread Raghavendra
On Thu, Feb 14, 2013 at 11:30 PM, Lonni J Friedman wrote: > I've got a postgres-9.2.x cluster, doing streaming replication to > several hot standby servers. I'd like to be able to query the master > to see the hostname or IP address of each connected streaming > replication standby server. > > I

[ADMIN] viewing the slaves which are connected to a master in streaming replication

2013-02-14 Thread Lonni J Friedman
I've got a postgres-9.2.x cluster, doing streaming replication to several hot standby servers. I'd like to be able to query the master to see the hostname or IP address of each connected streaming replication standby server. I know that I can view which servers are connected to the master by look