How to inspect db in django2.1 with postgresql?

Asked Jul 27 '19 at 14:17

Active Jul 27 '19 at 17:08

Viewed 428 times

hi when i run python3 manage.py inspectdb
it will return following error # The error was: sequence index must be integer, not 'slice'

same python3 manage.py inspectdb working on sqlite when i use postgresql it will return error

# Unable to inspect table 'zip_code
# The error was: sequence index must be integer, not 'slice'

edited Jul 27 '19 at 17:08

Hisham___Pak

asked Jul 27 '19 at 14:17

ArunKumar

i am using Django==2.1 and psycopg2==2.8.3 – ArunKumar Jul 27 '19 at 14:18
1

Please [edit] the question to include that detail, not a comment, and also include the tracebacks – roganjosh Jul 27 '19 at 14:24
How did you install Django and psycopg2? Did you use a virtual environment? Did you use Python 2 or Python 3? – ChrisGPT was on strike Jul 27 '19 at 14:27
Can you run `python3 manage.py dbshell`, that should put you into the postgres cli (psql), and from there try `\d zip_code`. This should show the schema of the table that is giving a problem. – Jamie Czuy Jul 27 '19 at 20:20
**Chris** i am using python3.6 and iam not using virtula environment – ArunKumar Jul 29 '19 at 05:03

0 Answers0