Just tried it -> same results.
FYI, I'm only using the interactive python shell to illustrate the
problem I face I my app...
On Feb 7, 4:56 pm, Michele Comitini <michele.comit...@gmail.com>
wrote:
> 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
