chatGPT is just a machine.

Apr 12, 2023130

AI Translation

This post is translated from Chinese into English through AI.View Original

AI-generated summary

The person asked chatGPT how to add a field to PostgreSQL after a specific field, but chatGPT only knew how to do it in MySQL and failed to execute the command. After multiple attempts and conversations, it was discovered that PostgreSQL does not support changing the order of fields.

I accidentally asked chatGPT how to implement the following requirement:

Add a field to PostgreSQL, and insert this field after a specific field.

chatGPT failed miserably and used solutions for MySQL:
ALTER TABLE moldata.main ALTER COLUMN energy SET AFTER moldata.eg;
It gave an error, and then confidently split it into two statements: first delete, then insert, but still gave an error.
We had this conversation over a dozen times...
Finally, after Googling, I discovered that PostgreSQL does not support changing the order of fields at all.