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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
