How to get column names of a vertex?

GSQL
#1

Hi All,
I am trying to get all column names of a vertex and wondering if there is a specific built-in function to list them? Any practice on it?

#2

Just confirming you are looking to retrieve the attribute names of vertices? In this case, you are looking for firstName , lastName , dob

Person

  • firstName
  • lastName
  • dob

You can fetch that information through an endpoint:
https://docs.tigergraph.com/dev/restpp-api/built-in-endpoints#show-graph-schema-metadata

$ curl -u tigergraph:tigergraph \
"localhost:14240/gsqlserver/gsql/schema?graph=workNet&type=company"

Alternatively, you can run LS if you’re interacting via GSQL shell:

GSQL shell
GSQL > ls
---- Global vertices, edges, and all graphs
Vertex Types:
  - VERTEX person(PRIMARY_ID name STRING, name STRING, age INT, gender STRING, state STRING) WITH STATS="OUTDEGREE_BY_EDGETYPE"
Edge Types:
  - UNDIRECTED EDGE friendship(FROM person, TO person, connect_day DATETIME)
​
Graphs:
  - Graph social(person:v, friendship:e)
Jobs:
​
​
Json API version: v2