> \l and \l+ show only the database name, owner and description. > select * from pg_database does not have date info, either. > > I would like to know when each of my databases were created.
The only solution I can think of is querying select oid, datname from pg_database; and then look up the timestamps of the corresponding directories in $PGDATA/base. Bye, Chris. -- Chris Mair http://www.1006.org ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
