W
W
WayMax2018-04-24 16:36:21
PostgreSQL
WayMax, 2018-04-24 16:36:21

Adminer or PostgreSQL generating syntax error when creating table from SQL editor?

If you create tables in the Adminer through the "master" - then everything is ok.
But when trying to create tables in the SQL query editor, a syntax error occurs on the first field of the table.
Problem in Adminer or PostgreSQL?
Advise a normal editor for PostgreSQL (no difference already under Windows or Linux).

Answer the question

In order to leave comments, you need to log in

3 answer(s)
S
sim3x, 2018-04-24
@sim3x

psql
without error text your question is useless

E
Eugene Wolf, 2018-04-24
@Wolfnsex

But when trying to create tables in the SQL query editor, a syntax error occurs on the first field of the table. Problem in Adminer or PostgreSQL?
Most likely the problem is in the SQL code you are trying to run/execute.
1. Navicat
2. EMS
3. SQL Maestro
4. PGAdmin-IV and PGAdmin III LTS from BigSQL
5. And others, like these or these , etc.
PS Of all this abundance, I personally liked: PGAdmin, Navicat and craft from EMS.

M
Maxim Fedorov, 2018-04-24
@Maksclub

Excellent Datagrip client from Jetbrains
Built into the entire line of IDEs (Phpstorm, Pycharm...)
https://habrahabr.ru/company/JetBrains/blog/316152/

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question