How to fetch data from tables in PostgreSQL

Started by vaibhav zaverialmost 8 years ago7 messagesgeneral

Jump to latest

vaibhav zaveri

vaibhavzaveri3@gmail.com

almost 8 years ago

Hi,

How to fetch data from tables in PostgreSQL.

Regards,
Vaibhav Zaveri

Import Notes

Reply to msg id not found: CABpWmTGOFjxDQbsvQ2=PKQ6=ghfNw0b+b8sd7iyYm2ks=BW96g@mail.gmail.comReference msg id not found: CABpWmTGt1ZHdjQ4L-Zp4HhSpKS4OC5Ke2G7w1HGzLwdb=QAmbg@mail.gmail.comReference msg id not found: CABpWmTGOFjxDQbsvQ2=PKQ6=ghfNw0b+b8sd7iyYm2ks=BW96g@mail.gmail.com

Thomas Kellerer

spam_eater@gmx.net

almost 8 years ago

In reply to: vaibhav zaveri (#1)

Re: How to fetch data from tables in PostgreSQL

vaibhav zaveri schrieb am 18.04.2018 um 09:22:

How to fetch data from tables in PostgreSQL.

That is done using the SELECT statement: https://www.postgresql.org/docs/current/static/sql-select.html

For an introduction on how to write queries, you might want to have a look at the Postgres tutorial:

https://www.postgresql.org/docs/current/static/tutorial-select.html

Thomas

Fabio Pardi

f.pardi@portavita.eu

almost 8 years ago

In reply to: vaibhav zaveri (#1)

Re: How to fetch data from tables in PostgreSQL

Hi Vaibhav,

I think this might come of help:

https://www.postgresql.org/docs/current/static/tutorial-select.html

Show quoted text

On 04/18/2018 09:22 AM, vaibhav zaveri wrote:

Hi,

How to fetch data from tables in PostgreSQL.

Regards,
Vaibhav Zaveri

novice

user.postgresql@gmail.com

almost 8 years ago

In reply to: vaibhav zaveri (#1)

Re: How to fetch data from tables in PostgreSQL

SELECT * FROM table_name LIMIT 10; should give 10 records from your data
table.

On Wed, 18 Apr 2018, 17:22 vaibhav zaveri, <vaibhavzaveri3@gmail.com> wrote:

Show quoted text

Hi,

How to fetch data from tables in PostgreSQL.

Regards,
Vaibhav Zaveri

vaibhav zaveri

vaibhavzaveri3@gmail.com

almost 8 years ago

In reply to: vaibhav zaveri (#1)

Re: How to fetch data from tables in PostgreSQL

Hi,

Thanks for your reply
Which are the important tables from which we need to get data?

Regards,
Vaibhav Zaveri

On 18 Apr 2018 12:52, "vaibhav zaveri" <vaibhavzaveri3@gmail.com> wrote:

Show quoted text

Hi,

How to fetch data from tables in PostgreSQL.

Regards,
Vaibhav Zaveri

Adrian Klaver

adrian.klaver@aklaver.com

almost 8 years ago

In reply to: vaibhav zaveri (#5)

Re: How to fetch data from tables in PostgreSQL

On 04/18/2018 12:38 AM, vaibhav zaveri wrote:

Hi,

Thanks for your reply
Which are the important tables from which we need to get data?

Important for what?

Regards,
Vaibhav Zaveri

On 18 Apr 2018 12:52, "vaibhav zaveri" <vaibhavzaveri3@gmail.com
<mailto:vaibhavzaveri3@gmail.com>> wrote:

Hi,

How to fetch data from tables in PostgreSQL.

Regards,
Vaibhav Zaveri

--
Adrian Klaver
adrian.klaver@aklaver.com

Melvin Davidson

melvin6925@gmail.com

almost 8 years ago

In reply to: Adrian Klaver (#6)

Re: How to fetch data from tables in PostgreSQL

On Wed, Apr 18, 2018 at 9:48 AM, Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

On 04/18/2018 12:38 AM, vaibhav zaveri wrote:

Hi,

Thanks for your reply
Which are the important tables from which we need to get data?

Important for what?

Regards,
Vaibhav Zaveri

On 18 Apr 2018 12:52, "vaibhav zaveri" <vaibhavzaveri3@gmail.com <mailto:
vaibhavzaveri3@gmail.com>> wrote:

Hi,

How to fetch data from tables in PostgreSQL.

Regards,
Vaibhav Zaveri

--
Adrian Klaver
adrian.klaver@aklaver.com

*>Which are the important tables from which we need to get data? *

*The whole idea of a relational database such as PostgreSQL, is that YOU
create the schema/tables that are important to you and you store *

*and retrieve the information that is important to you. When PostgreSQL is
first installed it cannot possibly have any tables/information that you*

*would consider important. *
--
*Melvin Davidson*
*Maj. Database & Exploration Specialist*
*Universe Exploration Command – UXC*
Employment by invitation only!