Skip site navigation (1) Skip section navigation (2)

Re: Welcome to the pgsql-admin list!

From: "Gibson Chimhamhiwa" <gchimhamhiwa(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Welcome to the pgsql-admin list!
Date: 2008-07-23 09:23:41
Message-ID: f2b0d8200807230223p2f9fb10i5d513c187f1df7a0@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi All,

I have a simple table below and I want to be able to traverse it using SQL.
Can somebody please advise me how I can do this in postgreSQL.

CREATE TABLE grouping
(
  grouping_id int4 NOT NULL,
  version int4,
  parent_grouping_id int4,
  topic_topic_id int4,
  CONSTRAINT grouping_pkey PRIMARY KEY (grouping_id),
  CONSTRAINT fk1e2e9d036852722d FOREIGN KEY (topic_topic_id)
      REFERENCES topic (topic_id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fk1e2e9d03a1bfbfe FOREIGN KEY (topic_topic_id)
      REFERENCES topic (topic_id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fk1e2e9d03cdaf7222 FOREIGN KEY (parent_grouping_id)
      REFERENCES grouping (grouping_id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITHOUT OIDS;
ALTER TABLE grouping OWNER TO napdba;

Thanks In Advance.

Gibson.

On Wed, Jul 23, 2008 at 11:12 AM, <pgsql-admin-owner(at)postgresql(dot)org> wrote:

> Welcome to the pgsql-admin mailing list!
> Your password at postgresql.org is
>
> QiFiDx
>
> To leave this mailing list, send the following command in the body
> of a message to majordomo(at)postgresql(dot)org:
>
> approve QiFiDx unsubscribe pgsql-admin gchimhamhiwa(at)gmail(dot)com
>
> This command will work even if your address changes.  For that reason,
> among others, it is important that you keep a copy of this message.
>
> To post a message to the mailing list, send it to
>  pgsql-admin(at)postgresql(dot)org
>
> If you need help or have questions about the mailing list, please
> contact the people who manage the list by sending a message to
>  pgsql-admin-owner(at)postgresql(dot)org
>
> You can manage your subscription by visiting the following WWW location:
>  <
> http://mail.postgresql.org/mj/mj_wwwusr/domain=postgresql.org/gchimhamhiwa%40gmail.com
> >
>
>
>  Put the text of the welcome message here.
>
>


-- 
Gibson Chimhamhiwa
CSIR - Meraka Institute
P O Box 395, Pretoria 0001
South Africa
www.csir.co.za / www.meraka.org.za
Office: +27 12 841 2758
Mobile: +27 78 447 2879
Fax: +27 12 841 4720
E-mail:gchimhamhiwa(at)gmail(dot)co(dot)za <E-mail%3Agchimhamhiwa(at)gmail(dot)co(dot)za>

Responses

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2008-07-23 14:39:42
Subject: Re: Welcome to the pgsql-admin list!
Previous:From: Francisco ReyesDate: 2008-07-22 19:30:21
Subject: Re: [ADMIN] shared_buffers and shmmax

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group