Hi Dag,
The patch adds the command "\dco" to list constraints in psql. This
seems useful to me.
Thank you!
The patch applies cleanly to HEAD, although some hunks have rather large
offsets.
As far as I can tell, the "\dco" command works as documented.
I have however found the following is
Hi All,
In the interests of trying to clean up the CF and keep things moving
I'll mark the patch rejected.
Thank you for managing the commitfest and the comments from many of
hackers. I apologize for not being able to email you more often due to
my busy day job.
First of all, I understand to
In the interests of trying to clean up the CF and keep things moving
I'll mark the patch rejected.
That doesn't mean the decision can't change or that nobody's allowed
to keep discussing it. It's just that that seems to be the decision
right now and there are too many patches queued up to keep thi
On Fri, Mar 25, 2022 at 3:20 PM Justin Pryzby wrote:
> \dX is similar, and I remember wondering whether it was really useful/needed.
> The catalog tables are exposed and documented for a reason, and power-users
> will learn to use them.
I don't think that \dX is comparable, because I don't think
On Fri, Mar 25, 2022 at 03:11:47PM -0400, Robert Haas wrote:
> On Fri, Mar 25, 2022 at 12:28 AM Greg Stark wrote:
> > Development of this seems to have stalled with the only review of this
> > patch expressing some skepticism about whether it's needed at all.
>
> Now, there is some precedent for
On Fri, Mar 25, 2022 at 12:28 AM Greg Stark wrote:
> Development of this seems to have stalled with the only review of this
> patch expressing some skepticism about whether it's needed at all.
My opinion on this patch is that we typically handle objects that are
essentially table properties by sh
Development of this seems to have stalled with the only review of this
patch expressing some skepticism about whether it's needed at all.
Unless anyone steps forward and says it's interesting I'm going to
mark it rejected?
I don't actually think it's a terrible idea myself but I think every
use c
"David G. Johnston" writes:
> On Monday, November 15, 2021, Tatsuro Yamada
> wrote:
>
> I don't know if this is a good example, but if you look at
> StackOverflow,
> it seems that people who want to see a list of constraints appear
> regularly.
>
> https://stackoverflow.com/q
Hi David,
Thanks for your comments.
Okay, but you agree that there are DBAs and users who want to see the
list of constraints, I think.
My opinion is this doesn't exist because there isn't any demand for it.
I don't know if this is a good example, but if you look at StackOverflow,
Hi Justin,
Thanks for your comments!
Currently, DBAs need the table name to see the constraint information.
Or, they can query pg_constraint or information_schema: check_constraints,
table_constraints.
Yeah, right.
If they can use the meta-command instead of a long query against pg_cons
On Monday, November 15, 2021, David G. Johnston
wrote:
>
> If the only motivation for this is "feature completion" - since we have so
> many other \d commands already implemented - I say we should pass.
>
If anything, doing this for triggers would be a much better feature.
The other missing lis
On Mon, Nov 15, 2021 at 5:23 PM Tatsuro Yamada <
tatsuro.yamada...@nttcom.co.jp> wrote:
>
> > I'm not confident that if I would use this, so let's wait to see if
> someone
> > else wants to give a +1.
>
> Okay, but you agree that there are DBAs and users who want to see the
> list of constraints,
Thanks for updating the patch :)
> Currently, DBAs need the table name to see the constraint information.
Or, they can query pg_constraint or information_schema: check_constraints,
table_constraints.
> - success = listConversions(pattern,
> show_verbose, show_system)
Hi Justin,
Thanks for your comments and review!
Maybe it ought to be possible to choose the type of constraints to show.
Similar to how \dt shows tables and \di shows indexes and \dti shows
tables+inds, you could run \dcoc for check constraints and \dcof for foreign
keys. But I think "\dco" is
Hi,
On Mon, Nov 15, 2021 at 10:38:55AM +0900, Tatsuro Yamada wrote:
> postgres=# \dco
> List of constsraints
> Schema | Name | Definition
> | Table
> +-+-
15 matches
Mail list logo
