Thread: Without schemas
Greetings:
I'm a PHP programmer and I've had some troubles on using PostgreSQL as Database Manager. The point is that I want to know if there is anyway one can create a table without inserting inside the "public" schema. What would be desirable is that my tables could be outside any schema. Perhaps this question is almost stupid because it shows a complete lack of knowledge about PostgreSQL, but I'm really new to it. I'm using Navicat for PostgreSQL and pgAdminIII with PostgreSQL 8.1
Thanks in advance.
Félix Sánchez Rodríguez wrote: > Greetings: > > I'm a PHP programmer and I've had some troubles on using PostgreSQL as > Database Manager. The point is that I want to know if there is anyway > one can create a table without inserting inside the "public" schema. > What would be desirable is that my tables could be outside any schema. > Perhaps this question is almost stupid because it shows a complete > lack of knowledge about PostgreSQL, but I'm really new to it. I'm > using Navicat for PostgreSQL and pgAdminIII with PostgreSQL 8.1 > > Thanks in advance. Hello Félix, The tables you create need not be in the public schema (they may be in another schema), but they cannot be "outside of any schema". all tables must be within a schema inside a database. However, leaving things in the public schema is the closest you'll get to what you are trying to accomplish. You can, for the most part, ignore the existence of schemas altogether by leaving all of your tables in public, and referring them to the not-fully-qualified name (the table name without the schema name). This might be counter-intuitive if you are looking at SQL code generated by tools such as Navicat, since those tools fully qualify the name of all database objects (i.e., public.tablename, etc.) . Doing so is not required (unless you've changed the default search_path in your postgresql.conf file) if you aren't using any special schemas, etc. -- Chander Ganesan Open Technology Group, Inc. One Copley Parkway, Suite 210 Morrisville, NC 27560 919-463-0999/877-258-8987 http://www.otg-nc.com Contact us about expert PostgreSQL training delivered worldwide!