Mysql4=# show data_directory;
data_directory
------------------------
/var/lib/pgsql/12/data
(1 row)
mysql4=# \dt+ myschema.table20
List of relations
Schema | Name | Type | Owner | Size | Description
----------+---------+-------+----------+------------+-------------
myschema | table20 | table | postgres | 8192 bytes |
(1 row)
mysql4=# create table test.emp(empno int primary key NOT NULL,ename varchar NOT NULL,job varchar,dob DATE,deptno int);
ERROR: schema "test" does not exist
LINE 1: create table test.emp(empno int primary key NOT NULL,ename v...
^
mysql4=# create table myschema.emp(empno int primary key NOT NULL,ename varchar NOT NULL,job varchar,dob DATE,deptno int);
CREATE TABLE
mysql4=#
mysql4=#
mysql4=# \dt +
ERROR: invalid regular expression: quantifier operand invalid
mysql4=#
mysql4=# select schemaname,relname from pg_stat_user_tables;
schemaname | relname
------------+---------
myschema | table20
myschema | emp
(2 rows)
mysql4=# create materialized view myschema.emp_mv as select * from myschema.emp;
SELECT 0
mysql4=#
mysql4=# select * from myschema.emp_mv;
empno | ename | job | dob | deptno
-------+-------+-----+-----+--------
(0 rows)
mysql4=# insert into myschema.emp values(100,'Ram','Admin','10-Jan-1973',10);
INSERT 0 1
mysql4=# insert into myschema.emp values(101,'ravan','Admin','10-Jan-1972',11);
INSERT 0 1
mysql4=# select * from myschema.emp_mv;
empno | ename | job | dob | deptno
-------+-------+-----+-----+--------
(0 rows)
mysql4=# refresh materialized view myschema.emp_mv;
REFRESH MATERIALIZED VIEW
mysql4=# select * from myschema.emp_mv;
empno | ename | job | dob | deptno
-------+----------+-------+------------+--------
100 | Ram | Admin | 1973-01-10 | 10
101 | ravan | Admin | 1982-01-10 | 11
