Re: ToDo List Item - System Table Index Clustering

Nicolas Barbier <nicolas.barbier@gmail.com>

From: Nicolas Barbier <nicolas.barbier@gmail.com>

To: Simone Aiken <saiken@ulfheim.net>

Cc: pgsql-hackers@postgresql.org

Date: 2011-01-16T11:29:37Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Add new buffers_backend_fsync field to pg_stat_bgwriter.
- 3134d8863e84 9.1.0 cited

2011/1/16 Simone Aiken <saiken@ulfheim.net>:

>        is there a way to make queries on the system tables show me what
>        is actually there when I'm poking around?  So for example:
>
>                Select * from pg_type limit 1;
>
>        tells me that the typoutput is 'boolout'.  An english string rather than
>        a number.  So even though the documentation says that column
>        maps to pg_proc.oid I can't then write:
>
>                Select * from pg_proc where oid = 'boolout';

Type type of typoutput is "regproc", which is really an oid with a
different output function. To get the numeric value, do:

Select typoutput::oid from pg_type limit 1;

Nicolas