Create a table in dbshell with django

Question

here is my code :

frontgreat=> CREATE TABLE contact_titlemessagesuggestion;
ERROR:  syntax error at or near ";"
LINE 1: CREATE TABLE contact_titlemessagesuggestion;

i don't understand why it's not working and why it's an syntax error.

frontgreat=> DROP TABLE contact_titlemessagesuggestion;
ERROR:  table "contact_titlemessagesuggestion" does not exist

have no syntax error and work fine.

Regards

Most databases require tables to have at least one column, so CREATE TABLE foo ( bar INT ); for example. — willeM_ Van Onsem
– willeM_ Van Onsem, Commented Oct 17, 2020 at 14:35

willeM_ Van Onsem · Accepted Answer · 2020-10-17 14:38:13Z

3

You can normally not create a table without any columns. Therefore one often either has to list the columns, or use for example a query that provides both data (but meta-data as well) to construct the columns in the table.

For example:

CREATE TABLE contact_titlemessagesuggestion (
    pk INT
);

answered Oct 17, 2020 at 14:38

willeM_ Van Onsem

482k33 gold badges483 silver badges624 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create a table in dbshell with django

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related