Home > mailing lists

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

From	KhunSanAung
Subject	How to store the PSQL command result into an array or Python dictionary?
Date	November 25, 2015 06:56:20
Msg-id	CAAQr1jZzbVrOd0eaj_K_GdC1wJZh5Q-OCqBxRLq3FhRGm0vcTQ@mail.gmail.com Whole thread Raw
Responses	Re: How to store the PSQL command result into an array or Python dictionary? (Yaser Raja <yrraja@gmail.com>) Re: How to store the PSQL command result into an array or Python dictionary? (Terry Schmitt <terry.schmitt@gmail.com>)
List	pgsql-admin

Hi All,

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

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:

From: KhunSanAung
Date: 25 November 2015, 06:36:28
Subject: How to create a read only user account to access to all pg database?

From: clingareddy@vsoftcorp.com
Date: 25 November 2015, 08:38:28
Subject: function nvl(numeric, integer) does not exist