Re: Add psql command to list 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);
> +				if (strncmp(cmd, "dco", 3) == 0) /* Constraint */
> +					switch (cmd[3])
> +					{
> +						case '\0':
> +						case '+':

Does "+" do anything ?

> +++ b/src/bin/psql/help.c
> @@ -231,6 +231,7 @@ slashUsage(unsigned short int pager)

>  	fprintf(output, _("  \\db[+]  [PATTERN]      list tablespaces\n"));
>  	fprintf(output, _("  \\dc[S+] [PATTERN]      list conversions\n"));
> +	fprintf(output, _("  \\dco[S] [PATTERN]      list constraint\n"));

Should be plural "constraints".

I think "exclude" should be called "exclusion" ("exclude" sounded to me like
you're going to provide a way to "exclude" types of constraints, like "xc"
would show everything except check constraints).

-- 
Justin