Postgres Pro
Downloads
Home   >   mailing lists

Re: find the template of a database in SQL - Mailing list pgsql-hackers

From Tom Lane
Subject Re: find the template of a database in SQL
Date
Msg-id 21167.1155918128@sss.pgh.pa.us
Whole thread Raw
In response to Re: find the template of a database in SQL  ("Walter Cruz" <walter.php@gmail.com>)
List pgsql-hackers
Tree view 
"Walter Cruz" <walter.php@gmail.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

pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: find the template of a database in SQL
Next
From: "korryd@enterprisedb.com"
Date:
Subject: Re: find the template of a database in SQL