为什么我在“alter”或附近会出现语法错误？

I am using PostgreSQL and just got this error. Here is my code

我正在使用PostgreSQL，只是出现了这个错误。这是我的代码

  alter table seatbooking 
  add foreign key (BookingId) 
  references FlightBooking(BookingId);

All I get is:

我得到的只是：

ERROR: syntax error at or near "alter"

错误：“alter”或其附近的语法错误

Can someone help me? thanks.

有人能帮我吗？谢谢。

1 个解决方案

Code looks correct so it's probably a copy paste error in your client. Just try to retype the entire thing in a new window. (don't copy paste)

代码看起来正确，所以它可能是您的客户端中的复制粘贴错误。试着在新窗口中重新输入整个内容。（不要复制粘贴）

Code looks correct so it's probably a copy paste error in your client. Just try to retype the entire thing in a new window. (don't copy paste)

代码看起来正确，所以它可能是您的客户端中的复制粘贴错误。试着在新窗口中重新输入整个内容。（不要复制粘贴）