Cuéntanos qué está pasando:
De momento imposible completar este curso; sólo saliendo de psql (\q) para luego ingresar nuevamente, me dá por validos los ejercicios realizados. De lo contrario me pide logguearme cada vez. Los ejercicios dan “correctos” al loguearme, aún si el codigo ingresado anteriormente contiene errores o está mal escrito…
Por últmo, al intentar resetear el curso para comenzar de cero, los errores persisten, así como persisten las tablas y base de datos creados antes del reset…
Estaría precisando la intervención de algún administrador de éste espacio.
Desde ya, muchas Gracias!
Tu código hasta el momento
codeally@ddb6eadf7842:~/project$ psql --username=freecodecamp --dbname=postgres
Border style is 2.
Title is " ".
Pager usage is off.
psql (12.9 (Ubuntu 12.9-2.pgdg20.04+1))
Type “help” for help.
postgres=> \l
postgres=> List of databases
±----------------±-------------±---------±--------±--------±----------------------+
| Name | Owner | Encoding | Collate | Ctype | Access privileges |
±----------------±-------------±---------±--------±--------±----------------------+
| first_database | freecodecamp | UTF8 | C.UTF-8 | C.UTF-8 | |
| postgres | postgres | UTF8 | C.UTF-8 | C.UTF-8 | |
| second_database | freecodecamp | UTF8 | C.UTF-8 | C.UTF-8 | |
| template0 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +|
| | | | | | postgres=CTc/postgres |
| template1 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +|
| | | | | | postgres=CTc/postgres |
±----------------±-------------±---------±--------±--------±----------------------+
(5 rows)
postgres=> drop database first_database
postgres-> ;
DROP DATABASE
postgres=> drop database second_database ;
DROP DATABASE
postgres=> \l
List of databases
±----------±---------±---------±--------±--------±----------------------+
| Name | Owner | Encoding | Collate | Ctype | Access privileges |
±----------±---------±---------±--------±--------±----------------------+
| postgres | postgres | UTF8 | C.UTF-8 | C.UTF-8 | |
| template0 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +|
| | | | | | postgres=CTc/postgres |
| template1 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +|
| | | | | | postgres=CTc/postgres |
±----------±---------±---------±--------±--------±----------------------+
(3 rows)
postgres=> \q
codeally@ddb6eadf7842:~/project$ psql --username=freecodecamp --dbnamepostgres
/usr/lib/postgresql/12/bin/psql: unrecognized option ‘–dbnamepostgres’
Try “psql --help” for more information.
codeally@ddb6eadf7842:~/project$ psql --username=freecodecamp --dbname=postgres
Border style is 2.
Title is " ".
Pager usage is off.
psql (12.9 (Ubuntu 12.9-2.pgdg20.04+1))
Type “help” for help.
postgres=> ?l
postgres-> \l
postgres-> List of databases
±----------±---------±---------±--------±--------±----------------------+
| Name | Owner | Encoding | Collate | Ctype | Access privileges |
±----------±---------±---------±--------±--------±----------------------+
| postgres | postgres | UTF8 | C.UTF-8 | C.UTF-8 | |
| template0 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +|
| | | | | | postgres=CTc/postgres |
| template1 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +|
| | | | | | postgres=CTc/postgres |
±----------±---------±---------±--------±--------±----------------------+
(3 rows)
postgres->
postgres-> ;
ERROR: syntax error at or near “?”
LINE 1: ?l
^
postgres=> \l
postgres=> List of databases
±----------±---------±---------±--------±--------±----------------------+
| Name | Owner | Encoding | Collate | Ctype | Access privileges |
±----------±---------±---------±--------±--------±----------------------+
| postgres | postgres | UTF8 | C.UTF-8 | C.UTF-8 | |
| template0 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +|
| | | | | | postgres=CTc/postgres |
| template1 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +|
| | | | | | postgres=CTc/postgres |
±----------±---------±---------±--------±--------±----------------------+
(3 rows)
postgres=> \l
postgres=> List of databases
±----------±---------±---------±--------±--------±----------------------+
| Name | Owner | Encoding | Collate | Ctype | Access privileges |
±----------±---------±---------±--------±--------±----------------------+
| postgres | postgres | UTF8 | C.UTF-8 | C.UTF-8 | |
| template0 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +|
| | | | | | postgres=CTc/postgres |
| template1 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +|
| | | | | | postgres=CTc/postgres |
±----------±---------±---------±--------±--------±----------------------+
(3 rows)
postgres=> \q
codeally@ddb6eadf7842:~/project$ psql --username=freecodecamp --dbname=postgres
Border style is 2.
Title is " ".
Pager usage is off.
psql (12.9 (Ubuntu 12.9-2.pgdg20.04+1))
Type “help” for help.
postgres=> CREATE DATABASE first_database;
CREATE DATABASE
postgres=> \q
codeally@ddb6eadf7842:~/project$ psql --username=freecodecamp --dbname=postgres
Border style is 2.
Title is " ".
Pager usage is off.
psql (12.9 (Ubuntu 12.9-2.pgdg20.04+1))
Type “help” for help.
postgres=> \l
postgres=> List of databases
±---------------±-------------±---------±--------±--------±----------------------+
| Name | Owner | Encoding | Collate | Ctype | Access privileges |
±---------------±-------------±---------±--------±--------±----------------------+
| first_database | freecodecamp | UTF8 | C.UTF-8 | C.UTF-8 | |
| postgres | postgres | UTF8 | C.UTF-8 | C.UTF-8 | |
| template0 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +|
| | | | | | postgres=CTc/postgres |
| template1 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +|
| | | | | | postgres=CTc/postgres |
±---------------±-------------±---------±--------±--------±----------------------+
(4 rows)
postgres=> \q
codeally@ddb6eadf7842:~/project$ psql --username=freecodecamp --dbname=postgres
Border style is 2.
Title is " ".
Pager usage is off.
psql (12.9 (Ubuntu 12.9-2.pgdg20.04+1))
Type “help” for help.
postgres=>
postgres=> CREATE DATABASE second_database;
CREATE DATABASE
postgres=> \q
codeally@ddb6eadf7842:~/project$ psql --username=freecodecamp --dbname=postgres
Border style is 2.
Title is " ".
Pager usage is off.
psql (12.9 (Ubuntu 12.9-2.pgdg20.04+1))
Type “help” for help.
postgres=> \l
postgres=> List of databases
±----------------±-------------±---------±--------±--------±----------------------+
| Name | Owner | Encoding | Collate | Ctype | Access privileges |
±----------------±-------------±---------±--------±--------±----------------------+
| first_database | freecodecamp | UTF8 | C.UTF-8 | C.UTF-8 | |
| postgres | postgres | UTF8 | C.UTF-8 | C.UTF-8 | |
| second_database | freecodecamp | UTF8 | C.UTF-8 | C.UTF-8 | |
| template0 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +|
| | | | | | postgres=CTc/postgres |
| template1 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +|
| | | | | | postgres=CTc/postgres |
±----------------±-------------±---------±--------±--------±----------------------+
(5 rows)
postgres=> psql --username=freecodecamp --dbname=postgres
postgres-> \l
postgres-> List of databases
±----------------±-------------±---------±--------±--------±----------------------+
| Name | Owner | Encoding | Collate | Ctype | Access privileges |
±----------------±-------------±---------±--------±--------±----------------------+
| first_database | freecodecamp | UTF8 | C.UTF-8 | C.UTF-8 | |
| postgres | postgres | UTF8 | C.UTF-8 | C.UTF-8 | |
| second_database | freecodecamp | UTF8 | C.UTF-8 | C.UTF-8 | |
| template0 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +|
| | | | | | postgres=CTc/postgres |
| template1 | postgres | UTF8 | C.UTF-8 | C.UTF-8 | =c/postgres +|
| | | | | | postgres=CTc/postgres |
±----------------±-------------±---------±--------±--------±----------------------+
(5 rows)
postgres-> \q
codeally@ddb6eadf7842:~/project$ psql --username=freecodecamp --dbname=postgres
Border style is 2.
Title is " ".
Pager usage is off.
psql (12.9 (Ubuntu 12.9-2.pgdg20.04+1))
Type “help” for help.
postgres=> \c second_database
You are now connected to database “second_database” as user “freecodecamp”.
second_database=> \q
codeally@ddb6eadf7842:~/project$ psql --username=freecodecamp --dbname=postgres
Border style is 2.
Title is " ".
Pager usage is off.
psql (12.9 (Ubuntu 12.9-2.pgdg20.04+1))
Type “help” for help.
postgres=> \c second_database
You are now connected to database “second_database” as user “freecodecamp”.
second_database=> \d
Did not find any relations.
second_database=>
Información de tu navegador:
El agente de usuario es: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36 Edg/112.0.1722.39
Challenge: Aprende bases de datos relacionales construyendo una base de datos Mario - Build a Mario Database
Enlaza al desafío: