views/LOG_SORTED.pg_sql

Views

Source

001: \echo Start views/LOG_SORTED.pg_sql
002: 
003: drop view if exists LOG_SORTED;
004: 
005: /** Wrapper over the log table to get newest entries first.
006:  *
007:  *  @view LOG_SORTED
008:  *  @version $Id: LOG_SORTED.pg_sql 24 2018-06-15 23:28:06Z thiemo $
009:  *  @todo Once HyperSQL supports a license tag, convert the corresponding
010:  *        info tag into one.
011:  *  @copyright Thiemo Kellner, 2018 -
012:  *  @info License LGPLv3
013:  *  @webpage https://www.sourceforge.net/projects/pglogger
014:  */
015: create view LOG_SORTED as
016:      select *
017:        from LOG
018:    order by ID desc;
019: 
020: 
021: comment on view LOG_SORTED is
022:   'Wrapper over the log table to get newest entries first.
023: $Header: svn+ssh://thiemo@svn.code.sf.net/p/pglogger/code/views/LOG_SORTED.pg_sql 24 2018-06-15 23:28:06Z thiemo $';
024: 
025: commit; -- unlike Oracle not all ddl commit implicitly
026: 
027: \echo End views/LOG_SORTED.pg_sql