Thread: How to retrieve object definition?

How to retrieve object definition?

From
"Yudie"
Date:
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

Re: How to retrieve object definition?

From
"A.Bhuvaneswaran"
Date:
> 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