0

I have written a wrong create statement in psql console.Create a database mytest and enter it.

postgres=# create database  mytest;
CREATE DATABASE
postgres=# \c mytest
You are now connected to database "mytest" as user "postgres".

Type a wrong statement and press enter ,it becomes:

mytest=# create table mytest(report text
mytest(#

Now i write a right statement :

mytest(#create table mytest(report text);

It can't execute ,no new table created ,maybe some cache in the psql ,how to remove them?

showkey
  • 482
  • 42
  • 140
  • 295
  • 1
    https://stackoverflow.com/questions/32632598/how-do-i-cancel-a-bad-command-in-postgres-from-terminal - type \r – mukunda Feb 07 '23 at 08:01

0 Answers0