Testing Compatibility with oracle using original reference |
postgres_vs_oracle2.htm |
|
Oracle : schema and users by default are the same. A schema is a
collection of database objects like table, views, sequences , stored
procedure, added under an user. PostgreSQL : schema is a namespace, containing objects like table, operators, functions and others, as shown below. This namespace is supposed to be granted to the users. Please refer : http://www.postgresql.org/docs/9.3/static/sql-createschema.html "CREATE SCHEMA IF NOT EXISTS test AUTHORIZATION joe;" |
What is Sequence: |
|
Note the table created under default schema 0; ( to repeat this example / drop the table and run again)." DROP TABLE IF EXISTS messages1;" |