Обсуждение: Re: Differentiate between system commands and user commands

Hi,

I would like to know how postgresql differentiates between the SQL
commands that are
entered by the user and the SQL commands that are executed internally by
the system
(for eg, to check the permissions of the user etc)?

Your response would be greatly appreciated.

Thanks and Regards,

Radha

Am Die, 2003-07-08 um 20.11 schrieb radha.manohar@ndsu.nodak.edu:
> Hi,
>
> I would like to know how postgresql differentiates between the SQL
> commands that are
> entered by the user and the SQL commands that are executed internally by
> the system
> (for eg, to check the permissions of the user etc)?

psql -E

> Your response would be greatly appreciated.

done

HTH
--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : http://www.e-trolley.de

<radha.manohar@ndsu.nodak.edu> writes:
> I would like to know how postgresql differentiates between the SQL
> commands that are
> entered by the user and the SQL commands that are executed internally by
> the system
> (for eg, to check the permissions of the user etc)?

There are no such "internal SQL commands".  Permissions checking is
hard-coded in C in the backend.

            regards, tom lane