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?