On Mon, Feb 02, 2004 at 05:10:00PM +0800, [EMAIL PROTECTED] wrote: > Using Postgresql 7.4.1, whenever I create a new database, it always contains > the following tables: sql_features, sql_implementation_info, sql_languages, > sql_packages, sql_sizing and sql_sizing_profiles. This is true whether I > use template1 or template0. Is this the case for earlier versions? I was > told by the developer of an applicatin that requires postgres, that the > newly created database should be empty. What gives?
It is empty. PostgreSQL uses various "system" tables to hold its own information. Use "\dt" to see a list of tables. It won't show you stuff that you don't need to worry about. Michael -- Michael Darrin Chaney [EMAIL PROTECTED] http://www.michaelchaney.com/ -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
