pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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 ?






Message-ID: <000101be690a$e53aad90$02237cd2@ns.hostbank.net>
Permalink:  ../000101be690a$e53aad90$02237cd2@ns.hostbank.net/
Also on:    postgresql.org/message-id/000101be690a$e53aad90$02237cd2@ns.hostbank.net

 · 

reply

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