PostgreSQL syntax error at or near INT

Question

I made a script to create a database with PostgreSQL. So I copy in my script, click "Analyze & Explain" in pgAdmin4 and I have no clue why it says I have a syntax error at or near 'INT' on idSituationFamiliale.

I really can't see what's wrong...

--Personnes
--
CREATE TABLE SITUATION_FAMILIALE (
    idSituationFamiliale INT NOT NULL,
    intituleSituationFamiliale VARCHAR(50) NOT NULL,
    PRIMARY KEY(idSituationFamiliale)
);

JGH · Accepted Answer · 2017-11-21 13:07:41Z

2

The query is fine if you RUN it. It is wrong if you EXPLAIN / ANALYZE it. The doc says that you can explain a CREATE TABLE AS, not a pure CREATE TABLE statement. While the former contains a SELECT statement that can be explained/analyzed, the later has nothing to be explained/analyzed and fails on the 1st field, regardless of its name or type.

answered Nov 21, 2017 at 13:07

JGH

18.2k5 gold badges40 silver badges57 bronze badges

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

1 Comment

Lucky-Luke87 Over a year ago

Okay, I will try to run the script as such asap ^^ Thank you :)

Debbie · Accepted Answer · 2017-11-21 12:55:00Z

-1

You should be using integer as opposed to int.

e.g

--Personnes
--
CREATE TABLE SITUATION_FAMILIALE (
idSituationFamiliale INTEGER NOT NULL,
intituleSituationFamiliale VARCHAR(50) NOT NULL,
PRIMARY KEY(idSituationFamiliale)
);

answered Nov 21, 2017 at 12:55

Debbie

495 bronze badges

6 Comments

Lucky-Luke87 Over a year ago

Hello, thanks for the response ^^ Unfortunately it doesn't change anything :/

Debbie Over a year ago

How about:

--Personnes     --     CREATE TABLE SITUATION_FAMILIALE (     idSituationFamiliale INTEGER PRIMARY KEY NOT NULL,     intituleSituationFamiliale VARCHAR(50) NOT NULL     );

user330315 Over a year ago

int is a valid alias for integer in Postgres

Debbie Over a year ago

Thanks! I hadn't realised.

Lucky-Luke87 Over a year ago

Still the same problem :/

|

Collectives™ on Stack Overflow

PostgreSQL syntax error at or near INT

2 Answers 2

1 Comment

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related