It looks like you're already inside the PostgreSQL prompt (postgres=#).

From your screenshot, you ran:

CREATE DATABASE first_database

PostgreSQL commands must end with a semicolon.

Correct command:

• CREATE DATABASE first_database;

After creating the database, you can verify it exists:

• \l

To connect to the new database:

• \c first_database

If it still doesn’t work, please share the exact error message shown in the terminal so we can help further.

In PostgreSQL, commands must end with a semicolon. Use CREATE DATABASE first_database;. You can list databases with \l and connect with \c first_database. If you are already at the postgres=# prompt, these commands will work. Ensure you have privileges to create databases.

VS Code bash is just a terminal — it doesn’t create databases by itself. The command will only work if the database software is installed and running.

First check:

• What database are you using? (MySQL, PostgreSQL, MongoDB?)
• Is the database server installed?
• Is the service running?

For example:

MySQL → make sure mysqld is running, then use mysql -u root -p

PostgreSQL → make sure postgres service is running, then use psql

If you’re getting an error, share the exact message. That will make it easier to diagnose.

It looks like you are in the PostgreSQL interactive terminal (postgres=#). In PostgreSQL, SQL commands must end with a semicolon. Use:

CREATE DATABASE first_database;

After that, you can list databases with \l and connect using \c first_database.

If you still face issues, verify:

• You have the necessary privileges (CREATEDB or superuser).
• The PostgreSQL server is running (systemctl status postgresql or pg_isready).
• You are connected to the correct instance (\conninfo shows connection details).
• Alternatively, use the createdb command-line tool: createdb first_database.

If you see a specific error, please share it for more targeted help.

🕒 Discussion Activity Reminder 🕒

This Discussion has been labeled as dormant by an automated system for having no activity in the last 60 days. Please consider one the following actions:

1️⃣ Close as Out of Date: If the topic is no longer relevant, close the Discussion as out of date at the bottom of the page.

2️⃣ Provide More Information: Share additional details or context — or let the community know if you've found a solution on your own.

3️⃣ Mark a Reply as Answer: If your question has been answered by a reply, mark the most helpful reply as the solution.

Note: This dormant notification will only apply to Discussions with the Question label. To learn more, see our recent announcement.

Thank you for helping bring this Discussion to a resolution! 💬