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

Re: command to Describe RULE

From: "PGMailList" <pgmail(at)pgexplorer(dot)com>
To: <tsmets(at)brutele(dot)be>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: command to Describe RULE
Date: 2002-03-27 12:37:44
Message-ID: 003901c1d58c$3199b820$05faa8c0@edios (view raw or flat)
Thread:
Lists: pgsql-general
select * from pg_rules

http://www.pgexplorer.com


----- Original Message -----
From: <tsmets(at)brutele(dot)be>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, March 27, 2002 3:19 AM
Subject: [GENERAL] command to Describe RULE


>
>
> I create a table (addresses) & its "historification".
> When an address is modified, it's moved to the historification which is
> basically a copy on "update" or "delete".
> I seem to have a proble & I wanna find the RULE I created to alter them.
> What command should I issue for that.
> I seem to not be able to find any \d command for that ...
> Could some one hint me ?
>
> Tx,
>
> Thomas,
>
> ===============================
>
>
>
> -- This table is really useless as such
> -- *************************************
> CREATE TABLE historification ( pkh SERIAL,
>                 -- This will be the moment the record is "archived"
>                                dateend TIMESTAMP DEFAULT
CURRENT_TIMESTAMP);
>
>
>
> -- Here is a basic address table
> CREATE TABLE addresses ( pk SERIAL,
>                          street CHAR(50) NOT NULL,
>                          street2 CHAR(50),
>                          zip CHAR(10) NOT NULL,
>                          city CHAR(30) NOT NULL,
>                          -- I have a table countries where the countries
>                          -- iso-codes are stored
>                          Country CHAR(2) REFERENCES COUNTRIES,
>                          datemodified TIMESTAMP DEFAULT
CURRENT_TIMESTAMP);
>
>
> -- Here is the PostgreSQL historification
> CREATE TABLE AddressHistorics ()
>        INHERITS (historification, addresses);
>
>
>
> CREATE RULE update_address AS
>     ON UPDATE TO addresses
>     DO
>         INSERT INTO AddressHistorics (pk, street, street2, zip, city,
> country, datemodified)
>             VALUES (old.pk, old.street, old.street2, old.zip, old.city,
> old.country, old.datemodified);
>
>
> CREATE RULE delete_address AS
>     ON DELETE TO Addresses
>     DO
>         INSERT INTO AddressHistorics (pk, street, street2, zip, city,
> country, datemodified)
>             VALUES (old.pk, old.street, old.street2, old.zip, old.city,
> old.country, old.datemodified);
>
>
> --
> Thomas SMETS
> rue J. Wytsmanstraat 62
> 1050 Bruxelles
> yahoo-id : smetsthomas
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>


In response to

pgsql-general by date

Next:From: Johann ZuschlagDate: 2002-03-27 13:21:10
Subject: Trigger does not work as expected
Previous:From: tonyDate: 2002-03-27 10:40:19
Subject: getting rid of characters in database

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