Thread: Re: Welcome to the pgsql-admin list!
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.
--
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
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
>>> "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