> On May 4, 2023, at 18:00, Wen Yi <chux...@outlook.com> wrote:
>
> Hi team,
> I am a newbie to the postgres.
> When I am studying the compiler,the text book tell me there is there type of
> compiler.
> • Assembly Language Format
> • Relocatable Binary Format
> • Memory-Image (Load-and-Go) Format
> I check the postgres's sql compiler, and it's achieved by lex & yacc.
> So What type of Compiler to SQL? Is Memory-Image (Load-and-Go) Format ?
Hi,
Those aren't really "types of compilers." They are different binary output
formats that a compiler can generate.
PostgreSQL does not have an "SQL compiler" as such. (It does have Just-in-Time
compilation for some operations, but that's almost certainly not what you are
looking for.) It's an interpreter, in that it transforms the input language to
an internal representation and then uses that for its execution, rather than
reducing it all the way to machine language.
