Postgresql SELECT & DELETE

This is the SELECT & DELETE commands in postgresql.

 

Show the list of tables and owner.

\d

 

See the data of table.

SELECT * FROM (table name);

 

 

Delete a row with condition.

DELETE FROM (schema).(table name) WHERE (table name).(column) = '(value)';