Notes about PostgreSQL: Difference between revisions
Jump to navigation
Jump to search
| Line 19: | Line 19: | ||
* drop database but tables are still there when creating the database again: [http://bytes.com/groups/postgresql/423960-drop-database-but-still-there]; reason: tables are in template1 db, and that is used as a template for creating the new database | * drop database but tables are still there when creating the database again: [http://bytes.com/groups/postgresql/423960-drop-database-but-still-there]; reason: tables are in template1 db, and that is used as a template for creating the new database | ||
* drop all tables in db: DROP SCHEMA public CASCADE; [http://archives.postgresql.org/pgsql-novice/2004-08/msg00272.php] | * drop all tables in db: DROP SCHEMA public CASCADE; [http://archives.postgresql.org/pgsql-novice/2004-08/msg00272.php] | ||
** you should create a new schema public again (especially if this is the template1 db): CREATE SCHEMA public; | |||
Revision as of 15:18, 24 July 2009
installation
Windows
- see http://www.postgresql.org/download/windows for current version
- eg. http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.3.7/win32/postgresql-8.3.7-1.zip
- don't install as a service
initdb "postgres" -D "petra" psql CREATE USER tom WITH PASSWORD 'myPassword';
nant createSQLStatements nant recreateDatabase nant resetDatabase
Some notes
- drop database but tables are still there when creating the database again: [1]; reason: tables are in template1 db, and that is used as a template for creating the new database
- drop all tables in db: DROP SCHEMA public CASCADE; [2]
- you should create a new schema public again (especially if this is the template1 db): CREATE SCHEMA public;