search

DASSL / ClassDB

An open-source system to let students experiment with relational data
https://dassl.github.io/ClassDB/
Other
7 stars 2 forks source link

Order of parameters in function public.describe is against convention (W) #118

Closed smurthys closed 7 years ago

smurthys commented 7 years ago

Making the schema name the default parameter means the schema name must be specified after the table name, which is inconsistent with the order in most facilities, including the convention of fully-qualified table name.

The solution is to not use the default parameter, and create two separate versions of the function with parameters in the expected order. (I believe this is how this function started, but was revised due to LOC concerns.)

smurthys commented 7 years ago

Sorry, I meant to say public.describe. I have edited the issue title.

For both versions of the function, it will be helpful to make the result match as close as possible to the \d psql command (except may be leave out modifiers column and index information)