SQL: relation already exists

51 views
Skip to first unread message

Yulia Tsareva

unread,
Apr 26, 2023, 2:13:22 AM4/26/23
to rextester
Hi,

I'm trying to run SQL code (using PostgreSQL) and as I can see some table names are already used.

42P07: relation "customers" already exists
42P07: relation "customer" already exists

I even can get data from customers table. However, if I create my own table and don't drop it, for next code run it is already cleared. So I don't understand why these tables "customers" and "customer" persist.

Are there some table names which I can't use? Or it is just a mistake and these tables should be dropped?

Best regards,
Yulia
Reply all
Reply to author
Forward
0 new messages