Re: [HACKERS] find the template of a database in SQL
> 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; I think Walter wants to know if a given table was defined in the current database, or if it was created from the template database (template0 or template1) when the database was created. I don't think you can 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). To find out where the table came from, you'd have to know which template your current database was cloned from and I don't think we store that info anywhere. -- Korry -- Korry Douglas [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com
Re: [HACKERS] find the template of a database in SQL
"Walter Cruz" <[EMAIL PROTECTED]> 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 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] find the template of a database in SQL
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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] find the template of a database in SQL
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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [HACKERS] find the template of a database in SQL
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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---(end of broadcast)--- TIP 6: explain analyze is your friend
[HACKERS] 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 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly