Postgres Pro
Downloads
Home   >   mailing lists

Re: How to store the PSQL command result into an array or Python dictionary? - Mailing list pgsql-admin

From Yaser Raja
Subject Re: How to store the PSQL command result into an array or Python dictionary?
Date
Msg-id CALkbEVnmrDx5_eEm+yCe_XugTR8Dg+Lt=9nzQ2qW4avtXv8RyQ@mail.gmail.com
Whole thread Raw
In response to How to store the PSQL command result into an array or Python dictionary?  (KhunSanAung <khunsanaung.gis@gmail.com>)
Responses Re: How to store the PSQL command result into an array or Python dictionary?
List pgsql-admin
Tree view
In PG 9.2 and above you can use the function row_to_json to get the result as a JSON. 

SELECT row_to_json(mytable) from myTable WHERE Country='Thailand' ;
                          row_to_json                           
----------------------------------------------------------------
 {"id":2,"subcontinent":"South-East Asia","country":"Thailand"}
(1 row)

You should be able to use this JSON for further processing in Python.

Regards
Yaser



On Tue, Nov 24, 2015 at 10:55 PM, KhunSanAung <khunsanaung.gis@gmail.com> wrote:
Hi All,

I have a postgres database with 'myTable' having three columns as followed.

id

SubContinent

 Country

1

South-East Asia

 Indonesia

2

South-East Asia

 Thailand

3

South-East Asia

 Malaysia

4

South-East Asia

 Singapore

5

South-East Asia

 Philippines

6

South-East Asia

 Vietnam

7

South-East Asia

 Myanmar

8

South-East Asia

 Brunei

9

South-East Asia

 Cambodia

10

South-East Asia

 Laos

11

South-East Asia

 Timor Leste

 

I want to filter & select the table with some condition.


SELECT SubContinent, Country from myTable WHERE Country='Thailand' ;


Accessing to pgdatabase via Python is okay for me.

Using the PSQL command via Python, I would like to select the columns and store the values in an array of dictionary like below.


dict= {'SubContinent': 'South-East Asia', 'Country': 'Thailand'}; 


How can I put the selection result into a Python dictionary?


Any help is highly appreciate.

Many thanks in advanced.


Best regards


--
Have a nice day!
--

Mr. Khun San Aung


pgsql-admin by date:

Previous
From: Felipe Santos
Date:
Subject: Re: Update postgresql-9.1 fails
Next
From: Yaser Raja
Date:
Subject: Re: Question on Hot Standby in PostgreSQL