Re: find the template of a database in SQL - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: find the template of a database in SQL
Date
Msg-id 44E5E834.5030303@commandprompt.com
Whole thread Raw
In response to Re: find the template of a database in SQL  ("Walter Cruz" <walter.php@gmail.com>)
Responses Re: find the template of a database in SQL
List pgsql-hackers
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
>



pgsql-hackers by date:

Previous
From: "Walter Cruz"
Date:
Subject: Re: find the template of a database in SQL
Next
From: Tom Lane
Date:
Subject: Re: find the template of a database in SQL