Velocity - Finding template name in PostgreSQL


Doc ID    SOL14433
Version:    2.0
Status:    Published
Published date:    10/13/2020
Created Date:    10/06/2020
 

Objective/Summary

In this article you will learn how to see template name in PostgreSQL database. 

Environment/Versions

Spirent Velocity

Procedure

After you've accessed your database, go to resource_template table and click on View/Edit Data -> All Rows. You will see a table with 3 columns (id, resourceid, templateid). 
If you want to add a new column to display the template name to this table follow below steps:
  1. Right click on resource_templates table -> Query Tool
  2. Add following query and execute :
                 SELECT rt.*, t.name FROM public.resource_templates rt
                 Join resources t on t.id = rt.templateid
                 ORDER BY id ASC

Find Answers

Specified Languages
English
中文

Please Sign In

Username
Password

Did you forget your password?
Click here for assistance

New user? Start here.