How SQL SELECT * statement works in Postgres?

Started by Sachin Srivastavaalmost 10 years ago4 messagesgeneral
Jump to latest
#1Sachin Srivastava
ssr.teleatlas@gmail.com

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&gt;

Regards,
SSR

#2Charles Clavadetscher
clavadetscher@swisspug.org
In reply to: Sachin Srivastava (#1)
Re: How SQL SELECT * statement works in Postgres?

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&gt;

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       |
|           _|  |                                      |
|           \|_/                                       |
|                                                      |
+------------------------------------------------------+

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#3Thomas Kellerer
spam_eater@gmx.net
In reply to: Sachin Srivastava (#1)
Re: How SQL SELECT * statement works in Postgres?

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&gt;

Check out Bruce's presentations:

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

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#4David G. Johnston
david.g.johnston@gmail.com
In reply to: Sachin Srivastava (#1)
Re: How SQL SELECT * statement works in Postgres?

On Sunday, June 5, 2016, Sachin Srivastava <ssr.teleatlas@gmail.com> 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&gt;

Why?

David J.