Answer the question
In order to leave comments, you need to log in
Can't see contents of Postgresql table. Why?
This is my first time using such a database...
Connected to a remote VPS server Ubuntu 16.04.
My actions:
su postgres
\connect my_table
\z
\d
Did not find any relations.
, or (0 rows)
. Answer the question
In order to leave comments, you need to log in
2. su postgres
3. \connect my_table
psql
didn't forget? \connect
requires the name of the database, by default the connection goes to the database with the name of the Linux user (i.e. in your case you are connecting to postgres). \l
\dn
\dt sname.
\d sname.my_table
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question