Re: INSERT for inherited tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: lbergman(at)abi(dot)tconline(dot)net
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: INSERT for inherited tables
Date: 2002-04-02 20:37:02
Message-ID: 27589.1017779822@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Lewis Bergman <lbergman(at)[nospam]abi(dot)tconline(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message tmorrison 2002-04-03 00:15:21 readline and psql
Previous Message V R 2002-04-02 08:49:05 how to rollback transactions in a function?