Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Run SQL text through the PostgreSQL parser and return syntax error information for each contained statement.

NotificationsYou must be signed in to change notification settings

jconway/pgsynck

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Run SQL text through the PostgreSQL parser and return syntax error information for each contained statement.

Usage example:--------------test=# select * from pgsyncktest-# ($$test$#     select '1;2;3/* not a comment */' from "My;Table" as from;test$#     select x from (select 1 as x);test$#     /* test;test */ begin;test$#     insert into foo2 values ('1''2','3;4');test$#     abort my transtest$# $$);-[ RECORD 1 ]-------------------------------------------------------------sql        |            |     select '1;2;3/* not a comment */' from "My;Table" as fromcursorpos  | 59sqlerrcode | 16801924message    | syntax error at or near "from"hint       | -[ RECORD 2 ]-------------------------------------------------------------sql        |            |     select x from (select 1 as x)cursorpos  | 20sqlerrcode | 16801924message    | subquery in FROM must have an aliashint       | For example, FROM (SELECT ...) [AS] foo.-[ RECORD 3 ]-------------------------------------------------------------sql        |            |     /* test;test */ begincursorpos  | 0sqlerrcode | 0message    | hint       | -[ RECORD 4 ]-------------------------------------------------------------sql        |            |     insert into foo2 values ('1''2','3;4')cursorpos  | 0sqlerrcode | 0message    | hint       | -[ RECORD 5 ]-------------------------------------------------------------sql        |            |     abort my trans           | cursorpos  | 12sqlerrcode | 16801924message    | syntax error at or near "my"hint       |

TODO:

  1. plpgsql syntax check?

About

Run SQL text through the PostgreSQL parser and return syntax error information for each contained statement.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages


[8]ページ先頭

©2009-2025 Movatter.jp