postgres=# \c students
You are now connected to database "students" as user "postgres".
students=# \dt;
public | student | table | postgres
students=# \dt+
public | student | table | postgres | 0 bytes |
students=#
What does the output of \dt
mean? I only only know there is a table student
under database students
beforehand.
I am using psql (9.6.6).
Thanks.
\dt
(no parameters) appears to list all the tables in the current schema, as the docs here explain: http://www.postgresonline.com/special_feature.php?sf_name=postgresql83_psql_cheatsheet
Your output is one row showing the (one) student table. If I create one table, similarly, I get this:
postgres=# \dt
List of relations
Schema | Name | Type | Owner
--------+---------+-------+--------
public | student | table | postgres
(1 row)
Do \dt+
to see slightly expanded information.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With