Skip to content

\d meta-command returns 8 rows, not 3, on my psql #79

@tmowad

Description

@tmowad

I'm happy to fix in a PR but want to be sure I'm not making a mistake first. Am new to postgres from mysql.

On http://postgresguide.com/sql/select.html when you do a \d the guide shows 3 rows (as 3 tables).

When I run \d I get 8 rows consisting of 4 tables and 4 sequences:
List of relations
Schema | Name | Type | Owner
--------+-----------------------+----------+--------
public | products | table | tmowad
public | products_id_seq | sequence | tmowad
public | purchase_items | table | tmowad
public | purchase_items_id_seq | sequence | tmowad
public | purchases | table | tmowad
public | purchases_id_seq | sequence | tmowad
public | users | table | tmowad
public | users_id_seq | sequence | tmowad

I'm a bit confused since on the prior page, it was clearly shown that there are 4 tables (which match up to mine).

Even when I do \dt (for tables only), I get 4 tables, not the 3 in the guide.

Is this clearly a mistake that I can fix in a PR? Did some postgres version change cause this or what?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions