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