Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
tmowad opened this issue Sep 18, 2016 · 1 comment
Open

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

tmowad opened this issue Sep 18, 2016 · 1 comment

Comments

@tmowad
Copy link

tmowad commented Sep 18, 2016

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?

@jjakenichol
Copy link

I have the same problem. It seems like the example dump was changed to something that doesn't fit the guide very well. It makes the guide cumbersome to follow.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants