Thread: Re: Welcome to the pgsql-admin list!

Re: Welcome to the pgsql-admin list!

From
"Gibson Chimhamhiwa"
Date:
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@postgresql.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@postgresql.org:

approve QiFiDx unsubscribe pgsql-admin gchimhamhiwa@gmail.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@postgresql.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@postgresql.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@gmail.co.za

Re: Welcome to the pgsql-admin list!

From
"Kevin Grittner"
Date:
>>> "Gibson Chimhamhiwa" <gchimhamhiwa@gmail.com> wrote:

> 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

SELECT * FROM grouping;

If that isn't what you're looking for, we need more information to be
able to help.

If you follow up on this, please start a new thread with a subject
line appropriate to the discussion; it will help the right people
notice your mail.

-Kevin