Select Postgresql Schemas in Python, output not as expected

Question

I'm trying to get all Schemas with "master" keyword in it. I got it, but my output looks like tuple parts and I would like only to get strings.

I did this:

def get_all_schemas():
    tmp_arr = []
    for name in db.engine.execute("""select schema_name from information_schema.schemata
                                    where schema_name like 'master%%' order by 1"""):
        tmp_arr.append({"name": name})
        print(tmp_arr)
    return tmp_arr

My output looks like:

[{'name': (u'master',)}, {'name': (u'master_old',)}, {'name': (u'master_old1',)}]

and I would like:

[{'name': 'master'}, {'name': 'master_old'}, {'name': 'master_old1'}]

Thanks

Community · Accepted Answer · 2017-05-23 12:14:37Z

1

Modification:

tmp_arr.append({"name": str(name[0])})

Sample:

a=(u'master',)    
str(a[0])
'master'

The output of your query is tuple with Unicode string so you can get first element using [0] and can convert it into acsii strings using str() for more on converting string see this SO question and this also

edited May 23, 2017 at 12:14

CommunityBot

11 silver badge

answered Aug 27, 2015 at 11:21

The6thSense

8,3559 gold badges38 silver badges67 bronze badges

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

Collectives™ on Stack Overflow

Select Postgresql Schemas in Python, output not as expected

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related