Re: [HACKERS] find the template of a database in SQL

2006-08-18 Thread [EMAIL PROTECTED]
> 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 def

Re: [HACKERS] find the template of a database in SQL

2006-08-18 Thread Tom Lane
"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 co

Re: [HACKERS] find the template of a database in SQL

2006-08-18 Thread Joshua D. Drake
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 sele

Re: [HACKERS] find the template of a database in SQL

2006-08-18 Thread Walter Cruz
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 templ

Re: [HACKERS] find the template of a database in SQL

2006-08-18 Thread Joshua D. Drake
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 sen