pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
How to retrieve object definition?
2+ messages / 2 participants
[nested] [flat]

* How to retrieve object definition?
@ 2003-04-18 20:57  Yudie <yudie@axiontech.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Yudie @ 2003-04-18 20:57 UTC (permalink / raw)
  To: pgsql-sql

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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: How to retrieve object definition?
@ 2003-04-19 06:55  A.Bhuvaneswaran <bhuvansql@myrealbox.com>
  parent: Yudie <yudie@axiontech.com>
  0 siblings, 0 replies; 2+ messages in thread

From: A.Bhuvaneswaran @ 2003-04-19 06:55 UTC (permalink / raw)
  To: Yudie <yudie@axiontech.com>; +Cc: pgsql-sql

> 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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2003-04-19 06:55 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-04-18 20:57 How to retrieve object definition? Yudie <yudie@axiontech.com>
2003-04-19 06:55 ` A.Bhuvaneswaran <bhuvansql@myrealbox.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox