documentation error

Started by PG Bug reporting formover 3 years ago2 messagesdocs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/14/functions.html
Description:

Dear all,

I am using

documentation says " The psql commands \df and \do can be used to list all
available functions and operators, respectively."

which clearly indicates that those are built in function , please correct me
if I am wrong and I went to the wrong part of the documentation.

-----------------------------------------------------

apple=# \df
List of functions
Schema | Name | Result data type | Argument data types |
Type
--------+------------------------+------------------+---------------------+------
public | update_modified_column | trigger | |
func
(1 row)

that is not what I was expecting , I was expecting a list of built-in
functions .

apple=# \do
List of operators
Schema | Name | Left arg type | Right arg type | Result type | Description

--------+------+---------------+----------------+-------------+-------------
(0 rows)

no resulets.

I would like to contribute also but I am new to postgresql. sorry.

thanks for taking the time to update and improve docs . you guys rock.

#2Daniel Gustafsson
daniel@yesql.se
In reply to: PG Bug reporting form (#1)
Re: documentation error

On 20 Aug 2022, at 12:39, PG Doc comments form <noreply@postgresql.org> wrote:

documentation says " The psql commands \df and \do can be used to list all
available functions and operators, respectively."

which clearly indicates that those are built in function , please correct me
if I am wrong and I went to the wrong part of the documentation.

From the psql documentation https://www.postgresql.org/docs/14/app-psql.html:

"By default, only user-created objects are shown; supply a pattern or
the S modifier to include system objects.

So \dfS is probably what you're looking for. Maybe making a link to the psql
page from the text you're referring to could be useful?

--
Daniel Gustafsson https://vmware.com/