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?
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?