Postgres Pro
Downloads
Home   >   mailing lists

Thread: Re: Differentiate between system commands and user commands

Re: Differentiate between system commands and user commands

From
Date:
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

Re: Differentiate between system commands and user

From
Nabil Sayegh
Date:
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

Re: Differentiate between system commands and user commands

From
Tom Lane
Date:
<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