[GENERAL] SQLite-PostgreSQL comparison

Does anyone know of a document comparing SQLite and PostgreSQL ? Thanks in advance. -- André Majorel http://www.teaser.fr/~amajorel/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Inspecting a DB - psql or system tables ?

Suppose you want to write a program that connects to a PostgreSQL database and lists its tables and views, the type of their columns and their relationships (REFERENCES) for automatic joins. Would you look at the system tables (pg_class et al.) or the output of psql \d, \dt, etc ? While parsing t