price_api/new_targets/tables/target_prices_view.pg.sql

11 lines
210 B
SQL

CREATE or REPLACE VIEW pricequote.target_prices_view AS
SELECT
stlc
,ds
,chan
,tier
,vol::text vol
,price
,to_jsonb(math)::text AS math
FROM
pricequote.target_prices;