Advertisement
Azamatik

Untitled

May 31st, 2024
843
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. psql-client:/# psql \
  2.         --host=postgresql-rw \
  3.         --port=5432 \
  4.         --username=app \
  5.         --password \
  6.         app
  7. Password:
  8. psql (16.3, server 16.2 (Debian 16.2-1.pgdg110+2))
  9. SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off)
  10. Type "help" for help.
  11.  
  12. app=> CREATE TABLE users (
  13. app(>     id SERIAL PRIMARY KEY,
  14. app(>     username VARCHAR(50),
  15. app(>     age INTEGER
  16. app(> );
  17. CREATE TABLE
  18. app=> INSERT INTO users (username, age) VALUES ('Alice', 25);
  19. ob', 30);
  20. INSERT INTO users (username, age) VALUESINSERT 0 1
  21. app=> INSERT INTO users (username, age) VALUES ('Bob', 30);
  22. ('Charlie', 28);
  23. INSERT INTO users (username, ageINSERT 0 1
  24. app=> INSERT INTO users (username, age) VALUES ('Charlie', 28);
  25. ) VALUES ('David', 35);
  26. INSERT INTO users (usernamINSERT 0 1
  27. app=> INSERT INTO users (username, age) VALUES ('David', 35);
  28. e, age) VALUES ('Eva', 22);
  29. INSERT INTO users (username, age) VALUES ('Frank', 40);
  30. INSERT INTO userINSERT 0 1
  31. app=> INSERT INTO users (username, age) VALUES ('Eva', 22);
  32. s (username, age) VALUES ('Grace', 33);
  33. INSERT INTINSERT 0 1
  34. app=> INSERT INTO users (username, age) VALUES ('Frank', 40);
  35. O users (username, age) VALUES ('Hannah', 29);
  36. INSINSERT 0 1
  37. app=> INSERT INTO users (username, age) VALUES ('Grace', 33);
  38. ERT INTO users (username, age) VALUES ('Iris', 27);
  39. INSERT INTO users (username, age) VALUES ('Jack'INSERT 0 1
  40. app=> INSERT INTO users (username, age) VALUES ('Hannah', 29);
  41. , 32);
  42. INSERT INTO users (username, age) VALUES ('INSERT 0 1
  43. app=> INSERT INTO users (username, age) VALUES ('Iris', 27);
  44. Kelly', 26);
  45. INSERT INTO users (username, age) VALUES ('Liam', 31);
  46. INSERT INTO users (username, ageINSERT 0 1
  47. app=> INSERT INTO users (username, age) VALUES ('Jack', 32);
  48. ) VALUES ('Mia', 24);
  49. INSERT INTO users (username,INSERT 0 1
  50. app=> INSERT INTO users (username, age) VALUES ('Kelly', 26);
  51. age) VALUES ('Noah', 37);INSERT 0 1
  52. app=> INSERT INTO users (username, age) VALUES ('Liam', 31);
  53. INSERT 0 1
  54. app=> INSERT INTO users (username, age) VALUES ('Mia', 24);
  55. INSERT 0 1
  56. app=> INSERT INTO users (username, age) VALUES ('Noah', 37);
  57. INSERT 0 1
  58. app=>
  59. app=>
  60. app=> select * from users;
  61. id | username | age
  62. ----+----------+-----
  63.  1 | Alice    |  25
  64.  2 | Bob      |  30
  65.  3 | Charlie  |  28
  66.  4 | David    |  35
  67.  5 | Eva      |  22
  68.  6 | Frank    |  40
  69.  7 | Grace    |  33
  70.  8 | Hannah   |  29
  71.  9 | Iris     |  27
  72. 10 | Jack     |  32
  73. 11 | Kelly    |  26
  74. 12 | Liam     |  31
  75. 13 | Mia      |  24
  76. 14 | Noah     |  37
  77. (14 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement