From: | "Weon-sun Lee" <randy(at)hostbank(dot)net> |
---|---|
To: | "[LIST] PostgreSQL-SQL" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Help: insert inheritance class |
Date: | 1999-03-08 02:25:12 |
Message-ID: | 000101be690a$e53aad90$02237cd2@ns.hostbank.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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 ?
From | Date | Subject | |
---|---|---|---|
Next Message | Remigiusz Sokolowski | 1999-03-08 07:29:45 | Re: [SQL] rules |
Previous Message | Manuel Lemos | 1999-03-08 01:28:59 | PostgreSQL EndTransactionBlock and not inprogress/abort state |