Thread: How SQL SELECT * statement works in Postgres?

How SQL SELECT * statement works in Postgres?

From
Sachin Srivastava
Date:
Dear Team,

Kindly inform to me How PostgreSQL Processes SQL Statements internally?



Regards,
SSR

Re: How SQL SELECT * statement works in Postgres?

From
Charles Clavadetscher
Date:
On 06/05/2016 11:16 AM, Sachin Srivastava wrote:
> Dear Team,
>
> Kindly inform to me How PostgreSQL Processes SQL Statements internally?
>
> How SQL SELECT * statement works in Postgres?
> <http://stackoverflow.com/questions/10927381/how-sql-select-statement-works-in-oracle>

I guess this is a good start:

https://www.postgresql.org/docs/9.5/static/overview.html

Regards,
Charles

>
>
> Regards,
> SSR

--
Charles Clavadetscher
Swiss PostgreSQL Users Group

http://www.swisspug.org
http://www.pgday.ch

+------------------------------------------------------+
|   ____  ______  ___                                  |
|  /    )/      \/   \         Swiss PGDay 2016        |
| (     / __    _\    ) 24.06.2016 - HSR CH-Rapperswil |
|  \    (/ o)  ( o)   )      http://www.pgday.ch       |
|   \_  (_  )   \ ) _/                                 |
|     \  /\_/    \)/         PostgreSQL 1996-2016      |
|      \/ <//|  |\\>         20 Years of Success       |
|           _|  |                                      |
|           \|_/                                       |
|                                                      |
+------------------------------------------------------+


Re: How SQL SELECT * statement works in Postgres?

From
Thomas Kellerer
Date:
Sachin Srivastava schrieb am 05.06.2016 um 11:16:
> Kindly inform to me How PostgreSQL Processes SQL Statements internally?
>
> How SQL SELECT * statement works in Postgres?
<http://stackoverflow.com/questions/10927381/how-sql-select-statement-works-in-oracle>
>
>
Check out Bruce's presentations:

http://momjian.us/main/presentations/internals.html

Specifically: http://momjian.us/main/writings/pgsql/internalpics.pdf



Re: How SQL SELECT * statement works in Postgres?

From
"David G. Johnston"
Date:


On Sunday, June 5, 2016, Sachin Srivastava <ssr.teleatlas@gmail.com> wrote:
Dear Team,

Kindly inform to me How PostgreSQL Processes SQL Statements internally?



 
Why?

David J.