Hello. First, some quick context about my approach (I am not a
programmer):

This is the directory where I installed Django: /Library/Python/2.6/
site-packages/django
This is my project directory: /Users/mlooby/Sites/mysite

Situation
1) I created a SQLite3 database, named "project.db," by editing
settings.py with the following:

        DATABASE_ENGINE = 'django.db.backends.sqlite3'
        DATABASE_NAME = '/Users/mlooby/Sites/mysite/project.db'

2) I created tables for the apps under INSTALLED_APPS by running:

        python manage.py syncdb

3) Next, I created my superuser account.

4) The tutorial then states the following:

        "If you're interested, run the command-line client for your database
and type \dt (PostgreSQL), SHOW TABLES; (MySQL), or .schema(SQLite) to
display the tables Django created."


My Issue: I cannot get SQLite to display the tables that Django just
created after entering/running the following in a new Terminal shell:

        mlooby$ sqlite3
        SQLite version 3.6.12
        Enter ".help" for instructions
        Enter SQL statements terminated with a ";"
        sqlite> .schema
        sqlite> .schema;
        unknown command or invalid arguments:  "schema;". Enter ".help" for
help
        sqlite> .schema project.db
        sqlite> .schema project
        sqlite> .schema project;
        sqlite>

I've reviewed www.sqlite.com and some related Google Groups, but my
searches were fruitless. Does anyone know why I can't get SQLite to
display the tables?

Finally, please let me know if I've omitted any information that would
help identify the issue.

Thank you.
-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en.


Reply via email to