python web2py/web2py.py -S courier
add -M
python web2py/web2py.py -S courier -M
mic
2012/2/7 Calycé <welcome.to.dev.n...@gmail.com>:
> Hi all,
>
> I'm starting a new project in which I'm using Postgresql, but I have
> some problems.
> I have defined a couple of tables in models/db.py. I can see and
> manipulate those tables through web2py's admin interface, but when I
> try to use DAL I'm facing some problems. I can connect without
> problem, but afterwards I can't see nor access any tables.
>
> Here's a copy of a python interactive session:
> (courier)[julie@landing courier]$ python web2py/web2py.py -S courier
> web2py Web Framework
> Created by Massimo Di Pierro, Copyright 2007-2011
> Version 1.99.3 (2011-12-09 16:18:03) stable
> Database drivers available: SQLite3, pymysql, PostgreSQL
> WARNING:web2py:import IPython error; use default python shell
> Python 2.7.2 (default, Jan 31 2012, 13:19:49)
> [GCC 4.6.2 20120120 (prerelease)] on linux2
> Type "help", "copyright", "credits" or "license" for more information.
> (InteractiveConsole)
>>>> db = DAL('postgres://postgres:********@localhost/courier')
>>>> print db.tables
> []
>>>>
>
> As you can see, I apparently have no tables in my database but I can
> definitely see them in web2py's admin interface!
> Am I doing something wrong ?
>
> Spec:
> Web2py: 1.99.3
> Postgres: 9.1.2
> Psycopg2: 2.4.4
