From: Weon-sun Lee <randy@hostbank.net>
To: [LIST] PostgreSQL-SQL <pgsql-sql@postgresql.org>
Subject: Help: insert inheritance class
Date: Mon, 8 Mar 1999 11:25:12 +0900
Message-ID: <000101be690a$e53aad90$02237cd2@ns.hostbank.net> (raw)
Hi there,
I'm create two classes. I'm sucess insert data into super class.
I want know how do I insert inherits class. Thanx.
First class
CREATE SEQUENCE auth_user_rowid;
CREATE TABLE auth_user (
"_rowid" int4,
"uid" text,
"username" text,
"password" text,
"perms" text );
INSERT INTO "auth_user" VALUES(nextval('auth_user_rowid'),
'aciefd90453092jfdaks','1022','Members');
this query is sucess....
CREATE TABLE members (
"stat" text,
"address" text,
"telephone" text,
"pcsphone" text,
"homepage" text,
"email" text,
"comment" text,
"changed" text) INHERITS( auth_user );
How do I insert data to members table ?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: randy@hostbank.net
Subject: Re: Help: insert inheritance class
In-Reply-To: <000101be690a$e53aad90$02237cd2@ns.hostbank.net>
References: <000101be690a$e53aad90$02237cd2@ns.hostbank.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox