Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Help with restoring a dump in Tar format? (dependencies/ordering) - Mailing list pgsql-general

From Ken Tanzer
Subject Re: [GENERAL] Help with restoring a dump in Tar format? (dependencies/ordering)
Date
Msg-id CAD3a31VjS=KNS95NPGVWw8gy3o=ijARAWuntr+i_vzhOV_Vsnw@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Help with restoring a dump in Tar format? (dependencies/ordering)  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: [GENERAL] Help with restoring a dump in Tar format? (dependencies/ordering)
List pgsql-general
Tree view
I do get the "make \d show relevant information" argument and that is one that seems easier to solve...

Maybe I'm missing something, but I'm not sure how you'd solve this or change what \d shows for a table.  Right now I get to see this in my \d:
"authorized_approvers_only" CHECK (approved_by IS NULL OR has_perm(approved_by, 'APPROVE_PAYMENT'::character varying, 'W'::character 
varying))
But when I move that to a trigger, I'll only see the trigger name.  Any while this procedure would be really short, others not so much, so you wouldn't really want to automatically display it inline.

Ken

--
AGENCY Software  
A Free Software data system
By and for non-profits
(253) 245-3801

learn more about AGENCY or
follow the discussion.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] Help with restoring a dump in Tar format? (dependencies/ordering)
Next
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] Help with restoring a dump in Tar format? (dependencies/ordering)