retrieving varchar from postgres using python

Question

from table country in postgres :

id  country_code country_desc
1   US           United States
2   GB           United Kingdom
3.  GR           Greece
4   CA           Canada

i retrieve column country_code using sqlalchemy.My db is set to utf-8:

 engine = sql.create_engine(connectionString)
    countries = engine.execute('select country_code from country')
    for country in countries:
        print(country)

which returns:

('US',)
('GB',)
('GR',)
('CA',)

instead of

    US
    GB
    GR
    CA

I have no idea why.

Saul Ramirez · Accepted Answer · 2020-01-24 22:14:25Z

1

Have you tried something like:

countries.country_code or countries.["country_code"]

answered Jan 24, 2020 at 22:14

Saul Ramirez

4262 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bonzay · Accepted Answer · 2020-01-24 22:19:04Z

0

 engine = sql.create_engine(connectionString)
    countries = engine.execute('select country_code from country')
    for country in countries:
        print(country[0])

did the job

answered Jan 24, 2020 at 22:19

Bonzay

7502 gold badges12 silver badges33 bronze badges

Collectives™ on Stack Overflow

retrieving varchar from postgres using python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related