Thread: find the template of a database in SQL
Hi all.. There's some way to find the template of a database in SQL (using 7.4)? []'s - Walter
Walter Cruz wrote: > Hi all.. > > There's some way to find the template of a database in SQL (using 7.4)? Find the template? Could you clarify your question? > > []'s > - Walter > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >
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' ? []'s - Walter On 8/18/06, Joshua D. Drake <jd@commandprompt.com> wrote: > Walter Cruz wrote: > > Hi all.. > > > > There's some way to find the template of a database in SQL (using 7.4)? > Find the template? Could you clarify your question? > > > > > []'s > > - Walter > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 1: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org so that your > > message can get through to the mailing list cleanly > > > >
Walter Cruz wrote: > 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' ? I do not believe that tables have templates in 7.4 unless you specifically use a query like: create table foo as select * from bar; Joshua D. Drake > > []'s > - Walter > On 8/18/06, Joshua D. Drake <jd@commandprompt.com> wrote: >> Walter Cruz wrote: >> > Hi all.. >> > >> > There's some way to find the template of a database in SQL (using >> 7.4)? >> Find the template? Could you clarify your question? >> >> > >> > []'s >> > - Walter >> > >> > ---------------------------(end of >> broadcast)--------------------------- >> > TIP 1: if posting/reading through Usenet, please send an appropriate >> > subscribe-nomail command to majordomo@postgresql.org so that >> your >> > message can get through to the mailing list cleanly >> > >> >> > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster >
"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
<blockquote type="CITE"><pre> <font color="#000000">> When I have a table that I don't know if it inherits from template 1,</font> <font color="#000000">> how can I find the 'super' ?</font> <font color="#000000">I do not believe that tables have templates in 7.4 unless you specifically</font> <font color="#000000">use a query like:</font> <font color="#000000">create table foo as select * from bar;</font> </pre></blockquote><br /> I think Walter wants to know if a given table was defined in the current database, or if it wascreated from the template database (template0 or template1) when the database was created.<br /><br /> I don't think youcan tell. When you create a new database from a template (typically template1), you're just making a copy of that template. It's not really inheritance (meaning that a change to the table definition in the template won't affect any databases"cloned" from that template).<br /><br /> To find out where the table came from, you'd have to know which templateyour current database was cloned from and I don't think we store that info anywhere.<br /><br /> -- Korry<br/><br /><table cellpadding="0" cellspacing="0" width="100%"><tr><td><br /><br /> --<br /> Korry Douglas <a href="mailto:korryd@enterprisedb.com">korryd@enterprisedb.com</a><br/> EnterpriseDB <a href="http://www.enterprisedb.com">http://www.enterprisedb.com</a></td></tr></table>