On Wed, Sep 11, 2019 at 10:03 AM Pavel Stehule wrote:
>
> st 11. 9. 2019 v 9:49 odesílatel Erik Rijkers napsal:
>>
>> On 2019-09-11 08:14, Pavel Stehule wrote:
>> > Hi
>> >
>> > [matviews not showing up in information_schema.tables]
>> >
>> > Is it expected behave? Tested on master branch.
>>
>>
st 11. 9. 2019 v 10:52 odesílatel Juan José Santamaría Flecha <
juanjo.santama...@gmail.com> napsal:
> On Wed, Sep 11, 2019 at 10:03 AM Pavel Stehule
> wrote:
> >
> > st 11. 9. 2019 v 9:49 odesílatel Erik Rijkers napsal:
> >>
> >> On 2019-09-11 08:14, Pavel Stehule wrote:
> >> > Hi
> >> >
> >> >
st 11. 9. 2019 v 9:49 odesílatel Erik Rijkers napsal:
> On 2019-09-11 08:14, Pavel Stehule wrote:
> > Hi
> >
> > [matviews not showing up in information_schema.tables]
> >
> > Is it expected behave? Tested on master branch.
>
> I think it is; it has been like this all along.
>
> ( matviews are in
On 2019-09-11 08:14, Pavel Stehule wrote:
Hi
[matviews not showing up in information_schema.tables]
Is it expected behave? Tested on master branch.
I think it is; it has been like this all along.
( matviews are in pg_matviews. )
Hi
create table omega(a int);
create view omega_view as select * from omega;
insert into omega values(10);
postgres=# select table_type, table_name from information_schema.tables
where table_name like 'omega%';
┌┬┐
│ table_type │ table_name │
╞╪╡
│
