\d command is used to list all table in a database.
Step 1: Create
a database myOrg.
createdb -U postgres -h localhost myOrg
Step 2: Login
to myOrg database and execute
the command \d to list all the tables in this database.
$psql -U postgres -h localhost --dbname=myOrg
Password for user postgres:
psql (14.4)
Type "help" for help.
myOrg=#
myOrg=# \d
Did not find any relations.
Create
table employee.
CREATE TABLE employee (id INT, name VARCHAR(20));
myOrg=# CREATE TABLE employee (id INT, name VARCHAR(20));
CREATE TABLE
myOrg=#
myOrg=# \d
List of relations
Schema | Name | Type | Owner
--------+----------+-------+----------
public | employee | table | postgres
(1 row)
No comments:
Post a Comment