How create a table inside the selected database in PostgreSQL?

Question

This is the command to create a new database,

CREATE DATABASE mydb;

This is the command to create a new table,

CREATE TABLE IF NOT EXISTS mytable ( int a PRIMARY KEY );

But this does not add the mytable inside the mydb. How to add the table inside the database mydb?

• Evan Carroll: what operating system are you using?
• Codename K: Windows 10 (64bit)

Answer 1

But this does not add the mytable inside the mydb. How to add the table inside the database mydb?

You have to connect to the database mydb,

psql -d mydb

Then run the command

• Evan Carroll: Where? Did you put a space between the dash and the d? -d?
• Evan Carroll: so where is that error coming from, I have no idea. Does your table name or column name have a - in it?
• Evan Carroll: @CodenameK do you have anything in your psqlrc?
• user1822: @CodenameK: you need to run that on the windows command line. That is not a SQL statement. You simply start psql and connect to the new database. If you already started psql you need to use \connect to switch to a different database
• Evan Carroll: If the database is dropped, you can't connect to it to see if the table exists. And no one can be connected to the database that you're dropping. You have to drop it while connecting to a different database.