bidder dt impressions_y2019m02 d27 List of relations Schema Name Type

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
bidder=# \dt+ impressions_y2019m02d27;
List of relations
Schema | Name | Type | Owner | Size | Description
--------+-------------------------+-------+--------+--------+-------------
public | impressions_y2019m02d27 | table | ubuntu | 217 MB |
(1 row)
bidder=# \d+ impressions_y2019m02d27;
Table "public.impressions_y2019m02d27"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
----------------+------------------------+-----------+----------+---------+----------+--------------+-------------
auction_id | character varying(254) | | not null | | extended | |
impressiondate | date | | not null | | plain | |
Partition of: impressions FOR VALUES FROM ('2019-02-27') TO ('2019-02-28')
Partition constraint: ((impressiondate IS NOT NULL) AND (impressiondate >= '2019-02-27'::date) AND (impressiondate < '2019-02-28'::date))
Indexes:
"impressions_y2019m02d27_key" btree (auction_id)