Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WXa3t-0007yv-OX for pgsql-admin@arkaria.postgresql.org; Tue, 08 Apr 2014 17:43:54 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WXa3s-0007Nl-A1 for pgsql-admin@arkaria.postgresql.org; Tue, 08 Apr 2014 17:43:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WXa3e-000711-94 for pgsql-admin@postgresql.org; Tue, 08 Apr 2014 17:43:38 +0000 Received: from qmta05.emeryville.ca.mail.comcast.net ([2001:558:fe2d:43:76:96:30:48]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WXa3Z-0004Cv-HG for pgsql-admin@postgresql.org; Tue, 08 Apr 2014 17:43:37 +0000 Received: from omta07.emeryville.ca.mail.comcast.net ([76.96.30.59]) by qmta05.emeryville.ca.mail.comcast.net with comcast id nSFL1n0031GXsucA5VjV0U; Tue, 08 Apr 2014 17:43:29 +0000 Received: from jerry.enova.com ([12.30.159.20]) by omta07.emeryville.ca.mail.comcast.net with comcast id nVjK1n0030ShjPw8UVjMwB; Tue, 08 Apr 2014 17:43:27 +0000 Received: by jerry.enova.com (Postfix, from userid 1001) id BF3DF7401E4; Tue, 8 Apr 2014 12:43:18 -0500 (CDT) From: Jerry Sievers To: Nik Tek Cc: "pgsql-admin\@postgresql.org" Subject: Re: How to find table creation time References: Date: Tue, 08 Apr 2014 12:43:18 -0500 In-Reply-To: (Nik Tek's message of "Fri, 4 Apr 2014 16:39:51 -0700") Message-ID: <86mwfvd8eh.fsf@jerry.enova.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.4 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=q20140121; t=1396979009; bh=4Lm3HF5Q2s2Zc6RyOq9M3UCDyBGhJLxA9wPgY9jlnwo=; h=Received:Received:Received:From:To:Subject:Date:Message-ID: MIME-Version:Content-Type; b=m2VYkwbQBwVwUuva/96sRt8SV02sTcfV0q9l+CGpA6Ft9e5/OkfTVN2Bd1FYHF0L8 R1Si95NeCVldu1qH29flJLZIjCFh/nWCAEpGktPfR8rliyuKgwV3THPHRvNg6SQ7m8 d+uE0TSzCHWzNHM4srYUqbkKnEo2vHmEZZqpn4fNZ0qvzK5HQHXlYgTYXgSwrRmnDD ENX18O1JBufntExlf64KHJqFd4+pYEKlberS0Z7swyfO23fnsLmoYfYnUlJbUtcxyS gWH5Nd9SnwMTlKDCLYg2ndXGHF9lKupsYBN7UUcNqO+vUry4v4TotCAu1VKidDQms6 SPwDpEPW6/E/Q== X-Pg-Spam-Score: -1.0 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Nik Tek writes: > Hi, > > Is there a way to find table creation time in postgres? > pg version is 9.0 Not retroactively unless (as already discussed here) you had DDL logging enabled. But see docs relating to EVENT triggers when you move to 9.3 or higher release at some point. > > Thank you > Nik > -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@comcast.net p: 312.241.7800 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin