From yudie@axiontech.com Fri Apr  18 20:45:34 2003
X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id C0DCC475E91
	for <pgsql-sql@postgresql.org>; Fri, 18 Apr 2003 16:45:34 -0400 (EDT)
Received: from axiontech.com (unknown [216.52.172.74])
	by postgresql.org (Postfix) with SMTP id C116B475458
	for <pgsql-sql@postgresql.org>; Fri, 18 Apr 2003 16:45:32 -0400 (EDT)
Received: (qmail 5089 invoked from network); 18 Apr 2003 20:45:34 -0000
Received: from unknown (HELO yudie) (192.168.1.132)
	by mail.axiontech.com (192.168.1.6) with SMTP;
	18 Apr 2003 20:45:34 -0000
Message-ID: <009201c305ed$22031040$8401a8c0@yudie>
From: "Yudie" <yudie@axiontech.com>
To: <pgsql-sql@postgresql.org>
Subject: How to retrieve object definition?
Date: Fri, 18 Apr 2003 15:57:32 -0500
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_008F_01C305C3.3892C410"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
X-Spam-Status: No, hits=1.6 required=5.0
	tests=HTML_20_30
	version=2.50
X-Spam-Level: *
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/289
X-Sequence-Number: 12990

This is a multi-part message in MIME format.

------=_NextPart_000_008F_01C305C3.3892C410
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,
I'm trying to get rule definition of Pgsql's rule... you know just like in
pgAdmin you can see create definition command of object like create table...
/ create rule....

I need to drop a rule, but before I drop it, I need to grab it's definition
first ,so I can recreate the same rule on the future.

I'm using Vb, any component can be use for this action?

Thank you

yudie
------=_NextPart_000_008F_01C305C3.3892C410
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4916.2300" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>Hi,<BR>I'm trying to get rule definition of Pgsql's rule... you know j=
ust=20
like in<BR>pgAdmin you can see create definition command of object like cre=
ate=20
table...<BR>/ create rule....<BR><BR>I need to drop a rule, but before I dr=
op=20
it, I need to grab it's definition<BR>first ,so I can recreate the same rul=
e on=20
the future.<BR><BR>I'm using Vb, any component can be use for this=20
action?<BR><BR>Thank you<BR><BR>yudie</DIV></BODY></HTML>

------=_NextPart_000_008F_01C305C3.3892C410--




From bhuvansql@myrealbox.com Sat Apr  19 06:45:27 2003
X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 7703E476351
	for <pgsql-sql@postgresql.org>; Sat, 19 Apr 2003 02:45:27 -0400 (EDT)
Received: from Gateway.bksys.co.in (unknown [61.3.64.6])
	by postgresql.org (Postfix) with ESMTP id 6E76947636E
	for <pgsql-sql@postgresql.org>; Sat, 19 Apr 2003 02:45:22 -0400 (EDT)
Received: from bksys.co.in (mail.bksys.co.in [192.168.1.1])
	by Gateway.bksys.co.in (8.11.6/8.11.6) with ESMTP id h3J6nlA04578;
	Sat, 19 Apr 2003 12:19:47 +0530
Received: from Bhuvan.bksys.co.in (Bhuvan.bksys.co.in [192.168.1.71])
	by bksys.co.in (8.11.6/8.8.5) with ESMTP id h3J6jik14628;
	Sat, 19 Apr 2003 12:15:44 +0530
Date: Sat, 19 Apr 2003 12:25:34 +0530 (IST)
From: "A.Bhuvaneswaran" <bhuvansql@myrealbox.com>
X-X-Sender: bhuvan@Bhuvan.bksys.co.in
To: Yudie <yudie@axiontech.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: How to retrieve object definition?
In-Reply-To: <009201c305ed$22031040$8401a8c0@yudie>
Message-ID: <Pine.LNX.4.44.0304191224160.1751-100000@Bhuvan.bksys.co.in>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Spam-Status: No, hits=-15.3 required=5.0
	tests=BAYES_00,IN_REP_TO,USER_AGENT_PINE
	autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/296
X-Sequence-Number: 12997

> I'm trying to get rule definition of Pgsql's rule... you know just like in
> pgAdmin you can see create definition command of object like create table...
> / create rule....

pg_rules system view could be of much help.

regards,
bhuvaneswaran