WRDS Python package error: psycopg2.errors.UndefinedColumn

230 Views Asked by At

According to WRDS (large data provider) itself, one can list the different libraries of data they provide by doing the following (source):

import wrds

db = wrds.Connection()

db.list_libraries()

This works fine for me. One can then look at all the different tables in a library by doing the following:

db.list_tables(library='comp')

where "comp", is an examplatory library.

However, when I do this, I get the following error:

ProgrammingError: (psycopg2.errors.UndefinedColumn) column c.relnamespace does not exist
LINE 1: ...me FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnames...
                                                             ^

[SQL: SELECT c.relname FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace WHERE n.nspname = %(schema)s AND c.relkind IN ('v', 'm')]
[parameters: {'schema': 'comp'}]
(Background on this error at: http://sqlalche.me/e/13/f405)

What is my mistake here? Thanks in advance.

0

There are 0 best solutions below