Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fQsjm-0000pc-AQ for pgsql-admin@arkaria.postgresql.org; Thu, 07 Jun 2018 11:05:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fQsjk-0001W9-Gl for pgsql-admin@arkaria.postgresql.org; Thu, 07 Jun 2018 11:05:48 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fQsjk-0001Vz-5a for pgsql-admin@lists.postgresql.org; Thu, 07 Jun 2018 11:05:48 +0000 Received: from n3.nabble.com ([162.255.23.22]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fQsjh-0008UN-2V for pgsql-admin@postgresql.org; Thu, 07 Jun 2018 11:05:46 +0000 Received: from n3.nabble.com (localhost [127.0.0.1]) by n3.nabble.com (Postfix) with ESMTP id 35F6CD592A2A for ; Thu, 7 Jun 2018 04:05:44 -0700 (MST) Date: Thu, 7 Jun 2018 04:05:44 -0700 (MST) From: pavan95 To: pgsql-admin@postgresql.org Message-ID: <1528369544218-0.post@n3.nabble.com> Subject: Adding date column to system catalog "pg_database" MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi all, Is it possible to add date column to "pg_database" view by altering the table? Reason is to get the created date of each database, I will schedule a trigger to update the date column with current server time. By this I can get the db creation date every now from the point of creation of new db. Any ideas in accomplishment of this task are of great help! Thanks in advance. Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html