Thread: How to fetch data from tables in PostgreSQL

How to fetch data from tables in PostgreSQL

From
vaibhav zaveri
Date:
Hi, 

How to fetch data from tables in PostgreSQL.

Regards, 
Vaibhav Zaveri

Re: How to fetch data from tables in PostgreSQL

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






Re: How to fetch data from tables in PostgreSQL

From
Fabio Pardi
Date:
Hi Vaibhav,

I think this might come of help:

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




On 04/18/2018 09:22 AM, vaibhav zaveri wrote:
> Hi, 
> 
> How to fetch data from tables in PostgreSQL.
> 
> Regards, 
> Vaibhav Zaveri


Re: How to fetch data from tables in PostgreSQL

From
Greenhorn
Date:
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:
Hi, 

How to fetch data from tables in PostgreSQL.

Regards, 
Vaibhav Zaveri

Re: How to fetch data from tables in PostgreSQL

From
vaibhav zaveri
Date:
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:
Hi, 

How to fetch data from tables in PostgreSQL.

Regards, 
Vaibhav Zaveri

Re: How to fetch data from tables in PostgreSQL

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


Re: How to fetch data from tables in PostgreSQL

From
Melvin Davidson
Date:


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!