| schema | name | column | data type |
|---|---|---|---|
| pg_catalog | svcs_error | context | char(100) |
| pg_catalog | svcs_error | errcode | int4 |
| pg_catalog | svcs_error | error | char(512) |
| pg_catalog | svcs_error | file | char(90) |
| pg_catalog | svcs_error | linenum | int4 |
| pg_catalog | svcs_error | pid | int4 |
| pg_catalog | svcs_error | process | char(32) |
| pg_catalog | svcs_error | recordtime | timestamp |
| pg_catalog | svcs_error | userid | int4 |
SELECT stcs_error.userid,
stcs_error.process,
CAST('1970-01-01 00:00:00' AS timestamp) + (CAST((CAST(stcs_error.recordtime AS numeric) / (1000.0 * 1000.0)) + 946684800.0 AS double precision) * CAST('00:00:01' AS interval)) AS recordtime,
stcs_error.pid,
stcs_error.errcode,
stcs_error.file,
stcs_error.linenum,
stcs_error.context,
stcs_error.error
FROM stcs_error Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers