Hello

> -----Original Message-----
> From: pgsql-general-ow...@postgresql.org 
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of hamann.w@t-
> online.de
> Sent: Donnerstag, 31. August 2017 08:56
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Table create time
> 
> 
> Hi,
> 
> is there a way to add a table create (and perhaps schema modify) timestamp to 
> the system?
> I do occasionally create semi-temporary tables (meant to live until a problem 
> is solved, i.e. longer than a session)
> with conveniently short names.

Unfortunately I can't help with this.

> Also, is there a simple query to identify tables without a table comment? (so 
> a weekly cron could remind me of
> tables that are already a few days old but have no explanatory comment)

Comments are stored in pg_catalog.pg_description. If there is an entry for your 
table then it has comments, otherwise not.

Example:

SELECT * FROM pg_description WHERE objoid = to_regclass('survey_control');

 objoid  | classoid | objsubid |                                                
                                                    description
---------+----------+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 2523030 |     1259 |        0 | Main table for survey management and control.
 2523030 |     1259 |        1 | The name of the survey.
 2523030 |     1259 |        2 | The year of conduction.
[...]

For tables the objsubid is 0 for the table comment and 1..n for column 
description. The number refers to the position of the column in the table.

Hope this helps.

Regards
Charles

> 
> I am running PG 9.3
> 
> Best regards
> Wolfgang Hamann
> 
> 
> 
> 
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make 
> changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to