<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>