Command line postgreSQL - create table

Q&A
#1

can someone tell me what is wrong with the create table command

thanks

/home/dq$ psql -d bank_accounts
psql (9.4.22)
Type “help” for help.

bank_accounts=# CREATE TABLE deposits(id integer PRIMARY KEY, name text, amount
float)
bank_accounts-# \dt
No relations found.

#2

I think the issue might be that there is no semicolon (;) at the end of your query, so the query never gets run. See if that resolves the issue — you might need to run the query twice if it errors the first time.

#3

Hi joshdq, thanks for the answer it helped