List databases:
db>
\lList of databases: db tutorial
Connect to a database:
db>
\c my_new_projectmy_new_project>
List modules:
db>
\lmList object types:
db>
\ltList scalar types:
db>
\lTList expression aliases (the -v includes the expression value in
the listing):
db>
\la -vDescribe an object type:
db>
\d Objectabstract type std::Object extending std::BaseObject {
required single link __type__ -> schema::Type {
readonly := true;
};
required single property id -> std::uuid {
readonly := true;
};
};Describe a scalar type:
db>
\d decimalscalar type std::decimal extending std::anynumeric;
Describe a function:
db>
\d sumfunction std::sum(s: SET OF std::float64) -> std::float64 {
volatility := 'Immutable';
using sql
;};
function std::sum(s: SET OF std::decimal) -> std::decimal {
volatility := 'Immutable';
using sql
;};
function std::sum(s: SET OF std::float32) -> std::float32 {
volatility := 'Immutable';
using sql
;};
function std::sum(s: SET OF std::bigint) -> std::bigint {
volatility := 'Immutable';
using sql
;};
function std::sum(s: SET OF std::int64) -> std::int64 {
volatility := 'Immutable';
using sql
;};
function std::sum(s: SET OF std::int32) -> std::int64 {
volatility := 'Immutable';
using sql
;};