On Mon, 2005-11-28 at 14:22 -0600, Announce wrote:
> Lets say I have the following tables.
>
> CREATE TABLE animals(id primary key, name varchar, type varchar);
> CREATE TABLE dogs (breed varchar) INHERITS (animals);
> CREATE TABLE birds (bool hasFeathers) INHERITS (animals);
r=# alter table birds alter type set default 'Bird';
ALTER TABLE
r=# \d birds
Table "public.birds"
Column | Type | Modifiers
-------------+-------------------+-----------------------------------
id | integer | not null
name | character varying |
type | character varying | default 'Bird'::character varying
hasfeathers | boolean |
Inherits: animals
r=# \d animals
Table "public.animals"
Column | Type | Modifiers
--------+-------------------+-----------
id | integer | not null
name | character varying |
type | character varying |
Indexes:
"animals_pkey" PRIMARY KEY, btree (id)
--
---------------------------(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
