TheLazy.Dev
Portfolio GitHub

Blog

Postgres Session 03

technonotes

technonotes-hacker

Posted on November 27, 2024

Postgres Session 03

Lets start to bug the Postgres

https://github.com/syedjaferk/postgres_sample_database/blob/main/dvd_rental/dvdrental.tar

Image description

Image description

Image description

  • Above all screenshots are my mistakes , I should use my OS user as POSTGRES then execute all commands.

Image description

Select queries

Commands

  • to drop the database --> DROP DATABASE ;
  • "-\" --> list the database
💖 💪 🙅 🚩
technonotes
technonotes-hacker

Posted on November 27, 2024

Join Our Newsletter. No Spam, Only the good stuff.

Sign up to receive the latest update from our blog.

Related

I am purposefully super nice to AI because I imagine they are trained on data where nice people get better help. Doing this, though, has an existential uneasiness to it.
ai I am purposefully super nice to AI because I imagine they are trained on data where nice people get better help. Doing this, though, has an existential uneasiness to it.

November 28, 2024

The best way to get better at writing code is...
development The best way to get better at writing code is...

November 28, 2024

If you're a beginner, definitely check this open source guide. I've explained almost everything you need to know.
undefined If you're a beginner, definitely check this open source guide. I've explained almost everything you need to know.

November 28, 2024

HMPL has a new logo. What do you think?
webdev HMPL has a new logo. What do you think?

November 28, 2024

I absolutely love when CSS gets new features (Even though it usually takes me years to remember to use them 😄)
undefined I absolutely love when CSS gets new features (Even though it usually takes me years to remember to use them 😄)

November 27, 2024