Learn Relational Databases by Building a Mario Database

Hi ,
I am working on: Learn Relational Databases by Building a Mario Database

Looks like they’re all gone. Remind yourself what columns you have in second_table by looking at its details.

I get following error:
\d second_table;
second_database=> Table “public.second_table”
| Column | Type | Collation | Nullable | Default |
| id | integer | | | |
| username | character varying(30) | | | |

\d second_table;
FATAL: terminating connection due to administrator command
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.

I tried “reset” several times, didn’t work. And server reset did not work.

Any suggestions?


When you use the login and connect commands do they work successfully?

psql --username=freecodecamp --dbname=postgres
\c <database>

That message occurs after you reset - the reset command kicks you off the database so it can be rebuilt. After you see that message, you are connected again - so you should be able to just run the command again.