Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aXytl-0004RV-Bw for pgsql-general@arkaria.postgresql.org; Mon, 22 Feb 2016 22:24:09 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aXytk-0001hF-Uo for pgsql-general@arkaria.postgresql.org; Mon, 22 Feb 2016 22:24:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aXyo0-0002jO-Nw for pgsql-general@postgresql.org; Mon, 22 Feb 2016 22:18:12 +0000 Received: from mail-wm0-x230.google.com ([2a00:1450:400c:c09::230]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1aXyny-0003vn-8P for pgsql-general@postgresql.org; Mon, 22 Feb 2016 22:18:12 +0000 Received: by mail-wm0-x230.google.com with SMTP id c200so193729010wme.0 for ; Mon, 22 Feb 2016 14:18:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=message-id:mime-version:to:cc:from:subject:date:in-reply-to :references:content-type; bh=rAMlbypAZDxhY+N0tfBA5TR8Up+0Hoiyd0dxbnB2ibw=; b=jqH+5b0eqp0VzPsuUXULgNQ6ihObMmgu5mqVMEzGk4Yrs5OR2MdfMlm80xDqNMqoxX v9UwEGa3rdrLTklLhwZNZ6CDI6PaGj1zNCdH1DDZxK5+WeQJ3n2Fvlv3zoFTWyPGJSjr jpOpNM2tq7ZPDhq+l71zPzoWUncVoKq2/KSLU8p6edHAB6lgT0KUoKW67HVimsfSNMvE ez2yLv2a2gJ0CIiiGi02o2cZj/VkxKVGdzPbQejcNKEItJ7KbqDldYzLYHrSZtdapv/H vit9cynp1xXfxYxShdm8Yft+vcAZ6UzEJqc2eftvmRJWT4hmUh5rNlmkAljH7UiYOUJd Cf1Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:message-id:mime-version:to:cc:from:subject:date :in-reply-to:references:content-type; bh=rAMlbypAZDxhY+N0tfBA5TR8Up+0Hoiyd0dxbnB2ibw=; b=LwipCAvQoyT14Vo7gYO3j8JoLGoPg4J4ipU//dMmQiOIMo/CrNM7eGbmwXJYTfWiea RZl3nTKAPDO933LGKuJjDfIuNVljKpbZ+4WBBNTOHtGik7oM7PX5f+tbH5v7LfdCxzQi b5SzQOZqNZbHmZHQKdYvdhVn1u2bsLdwK6wB4bsgmUGTs/KLtXClGrdh9BC+KdPa41YD vvKazkvZconZH0/Jc5MqQAkB1fTBaqsbVaYfZHsRMSNZ5sV3IdqbwaS8jhXK3IDxyPp0 VY0bMji7q/OZTlVn/F2wt/liq4PC1Jt10tb2cIgpb4cD55ySXTcAxuA4LEBKHkanIoQb CiEA== X-Gm-Message-State: AG10YOR+PtI4ywGimtOVZVKxnZD21J7ZvoTFOs+DHKF/v8bMGnotb761YT3a8mg3ml8u7Q== X-Received: by 10.194.209.204 with SMTP id mo12mr33287590wjc.69.1456179488921; Mon, 22 Feb 2016 14:18:08 -0800 (PST) Received: from [192.168.13.103] ([93.152.142.30]) by smtp.gmail.com with ESMTPSA id l7sm26716227wjx.14.2016.02.22.14.18.07 (version=TLSv1/SSLv3 cipher=OTHER); Mon, 22 Feb 2016 14:18:08 -0800 (PST) Message-ID: <56cb8920.c74fc20a.c69fa.5153@mx.google.com> MIME-Version: 1.0 To: "David G. Johnston" , "Edson F. Lidorio" Cc: pgsql-general From: Zlatko Asenov Subject: Re: Get the date of creation of objects in the database Date: Tue, 23 Feb 2016 00:18:02 +0200 In-Reply-To: References: <56CB84F7.20803@openmailbox.org> Content-Type: multipart/alternative; boundary="_43C2B8DB-FBA7-49EE-BEA9-36974299D8B1_" X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org --_43C2B8DB-FBA7-49EE-BEA9-36974299D8B1_ Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="utf-8" You may find useful a SIEM to record activity like this.=20 -----Original Message----- From: "David G. Johnston" Sent: =E2=80=8E2/=E2=80=8E23/=E2=80=8E2016 0:14 To: "Edson F. Lidorio" Cc: "pgsql-general" Subject: Re: [GENERAL] Get the date of creation of objects in the database On Mon, Feb 22, 2016 at 3:00 PM, Edson F. Lidorio w= rote: Hello, How to get the date of creation of objects in batabase? For example: The date of creation of tables and trigger. =E2=80=8BThe only source of data for that question is the local filesystem.= If that is acceptable you can find examples online provided to others who= have asked this question. If you want something internal to the database the answer is no. Those sam= e searches will turn up the various reasons why such a feature has not gott= en any strong traction from the developers. This was my search query: "postgresql object creation time" David J.= --_43C2B8DB-FBA7-49EE-BEA9-36974299D8B1_ Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="utf-8"
You may find useful a SIEM to record activity like this. =
From: David G. Johnston
Sent: =E2=80=8E2/= =E2=80=8E23/=E2=80=8E2016 0:14
To: Edson F. Lidorio
Cc: pgsql-general
= Subject: Re: [GENERAL] Get the date of creation of objects in the database

On Mon, Feb 22, 2016 at 3:00 PM, Edson F. Lidorio <edson@openmailbox.org> wrote:
Hello,
=0A=
=0A= How to get the date of creation of objects in batabase?
=0A= For example: The date of creation of tables and trigger.

=E2=80=8BThe only source of data for that question i= s the local filesystem.  If that is acceptable you can find examples o= nline provided to others who have asked this question.

=
If you want something internal to the database the answer is no. = Those same searches will turn up the various reasons why such a feature ha= s not gotten any strong traction from the developers.

<= div class=3D"gmail_default" style=3D"font-family: arial,helvetica,sans-seri= f;">This was my search query:  "postgresql object creation time"
=

David J.

= =0A= = --_43C2B8DB-FBA7-49EE-BEA9-36974299D8B1_--