Thread

1. manual for syntax for pg Query Tool

   Richard Bernstein <richb201@gmail.com> — 2020-06-20T01:45:03Z

   My script is for mySQL and I need to run it on the Query Tool. The very
   first line which starts with a # (it is a comment) fails. Is there any
   document that describes the acceptable syntax for a script running in the
   Query Tool?
   

2. Re: manual for syntax for pg Query Tool

   Anthony E . Greene <agreene@pobox.com> — 2020-06-23T22:52:31Z

   On 19-Jun-2020/21:45 -0400, Richard Bernstein <richb201@gmail.com> wrote:
   >My script is for mySQL and I need to run it on the Query Tool. The very
   >first line which starts with a # (it is a comment) fails. Is there any
   >document that describes the acceptable syntax for a script running in the
   >Query Tool?
   
   If by "Query Tool" you mean the query capability in pgAdmin, it uses
   standard SQL syntax. Two dashes starts a single-line comment and
   slash-asterisk starts a (potentially) multi-line comment.
   
   Hash marks for comments are typical of shell scripts, not SQL.
   
   PostgreSQL is compliant with standard SQL, and offers alternatives and
   shortcuts in addition to its support for standard SQL. The best
   documentation I know of is at https://www.postgresql.org/docs/manuals/
   
   
   TG
   -- 
   Anthony E. Greene <mailto:agreene@pobox.com>
   
   
   
   
   

3. Re: manual for syntax for pg Query Tool

   Laurenz Albe <laurenz.albe@cybertec.at> — 2020-06-24T06:17:15Z

   On Tue, 2020-06-23 at 18:52 -0400, Anthony E. Greene wrote:
   > PostgreSQL is compliant with standard SQL
   
   We strive to stick close to it, but saying that we are compliant is
   an exaggeration.
   
   Yours,
   Laurenz Albe
   -- 
   Cybertec | https://www.cybertec-postgresql.com