262Project/show_all.sql at main · AliceeLe/262Project · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
-- Show all contents of the database tables
\c project

\echo =============================
\echo Displaying contents of the "Users" table:
\echo =============================

-- Query the Users table
SELECT * FROM Users;

\echo =============================
\echo Displaying contents of the "Channel" table:
\echo =============================

-- Query the Channel table
SELECT * FROM Channel;

\echo =============================
\echo Displaying contents of the "Messages" table:
\echo =============================

-- Query the Messages table
SELECT * FROM Messages;

\echo =============================
\echo Displaying contents of the "Servers" table:
\echo =============================

-- Query the Servers table
SELECT * FROM Servers;

\echo =============================
\echo Displaying contents of the "Membership" table:
\echo =============================

-- Query the Membership table
SELECT * FROM Membership;

\echo =============================
\echo Displaying contents of the "Posts" table:
\echo =============================

-- Query the Posts table
SELECT * FROM Posts;

\echo =============================
\echo Displaying contents of the "Bots" table:
\echo =============================

-- Query the Bots table
SELECT * FROM Bots;

\echo =============================
\echo Displaying contents of the "APIDevelopment" table:
\echo =============================

-- Query the APIDevelopment table
SELECT * FROM APIDevelopment;

\echo =============================
\echo Displaying contents of the "Ads" table:
\echo =============================

-- Query the Ads table
SELECT * FROM Ads;

\echo =============================
\echo Displaying contents of the "Partnership" table:
\echo =============================

-- Query the Partnership table
SELECT * FROM Partnership;

\echo =============================
\echo Displaying contents of the "Moderator" table:
\echo =============================

-- Query the Moderator table
SELECT * FROM Moderator;

\echo =============================
\echo Displaying contents of the "Permission" table:
\echo =============================

-- Query the Permission table
SELECT * FROM Permission;


\echo =============================
\echo End of database dump.
\echo =============================