Re: find the template of a database in SQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Walter Cruz" <walter(dot)php(at)gmail(dot)com>
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: find the template of a database in SQL
Date: 2006-08-18 16:22:08
Message-ID: 21167.1155918128@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Walter Cruz" <walter(dot)php(at)gmail(dot)com> writes:
> well, when I create a database, it inherits from template1
> When I have a table that I don't know if it inherits from template 1,
> how can I find the 'super' ?

There isn't any persistent "inheritance" relationship for databases.
CREATE DATABASE just copies the source database at the instant of
creation, and that's the end of it.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Naz Gassiep 2006-08-18 16:28:51 pg_dump schema breakup
Previous Message Joshua D. Drake 2006-08-18 16:17:56 Re: find the template of a database in SQL