---
title: "Discussion on \"My PostgreSQL Cheat Sheet\" | Hashnode"
description: "Discussion on \"My PostgreSQL Cheat Sheet\". 1. Show tables\nThe command \\dt stands for describe tables and shows all tables in the database, equivalent to show tables in MySQL.\n\\dt\n2. Create user\nRun the following SQL command to create a user. Replace  and 'password' with the desired username a..."
url: "https://hashnode.com/posts/my-postgresql-cheat-sheet/6532ca9e79b36a2b4bab06ce"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [My PostgreSQL Cheat Sheet](https://schmidtdennis.de/my-postgresql-cheat-sheet?utm_source=hashnode&utm_medium=feed)

1\. Show tables The command \\dt stands for describe tables and shows all tables in the database, equivalent to show tables in MySQL. \\dt 2. Create user Run the following SQL command to create a user. Replace and 'password' with the desired username a...

Oct 20, 2023 · 1 min read · schmidtdennis.de  
Read the article

-   [#postgresql](https://hashnode.com/tag/postgresql)

## Written by

[Dennis Schmidt](https://hashnode.com/@schmidtdennis)

@schmidtdennis · Germany

  
[View profile](https://hashnode.com/@schmidtdennis)

Software Engineer at BMW

Software Engineer at BMW, Oracle Certified Professional Java SE 11 Developer

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
