Re: INSERT for inherited tables - Mailing list pgsql-novice

From Tom Lane
Subject Re: INSERT for inherited tables
Date
Msg-id 27589.1017779822@sss.pgh.pa.us
Whole thread Raw
In response to INSERT for inherited tables  (Lewis Bergman <lbergman@[nospam] abi.tconline.net>)
List pgsql-novice
Lewis Bergman <lbergman@[nospam]abi.tconline.net> writes:
> In the manual in the inherited section there is no mention or an example of
> how to do an insert into such a table. It also isn't addressed in the insert
> section. Undoubtedly this means everyone else is perfectly clear on the
> subject. Alas, I am not.

INSERT always inserts into exactly the table you name in the INSERT
command; it doesn't matter whether that table has inheritance children
(or parents).

            regards, tom lane

pgsql-novice by date:

Previous
From: Lewis Bergman
Date:
Subject: INSERT for inherited tables
Next
From: tmorrison
Date:
Subject: readline and psql