| |
| |
| https://www.modb.pro/db/33446 |
| |
| SELECT reltuples::bigint |
| FROM pg_catalog.pg_class |
| WHERE relname = 'tablename'; |
| |
| |
| SELECT COUNT(*) FROM tablename |
| |
| |
| [SugarColumn(ColumnName = "countries", ColumnDescription = "国家", ColumnDataType = "text []", IsArray = true, IsNullable = true)] |
| public string[] countries { get; set; } |
| |
| [SugarColumn(ColumnName = "emails", ColumnDescription = "电子邮件", ColumnDataType = "JSONB", IsJson = true, IsNullable = true)] |
| public object? emails { get; set; } |
| |
| |
| SELECT skills, skills[1] |
| FROM linkedin_data_demo |
| WHERE EXISTS ( |
| SELECT 1 |
| FROM unnest(skills) AS skill |
| WHERE skill = 'economics' |
| ) |
| LIMIT 10 |
| |
| |
| |
| SELECT data_id, jsonb_array_elements(languages)::json ->> 'name' |
| FROM linkedin_data_demo |
| WHERE EXISTS ( |
| SELECT 1 |
| FROM jsonb_array_elements(languages) AS lang |
| WHERE lang->>'name' = 'french' |
| ) |
| LIMIT 10 |
| |
| |
| SELECT data_id, jsonb_array_elements(languages) ->> 'name' |
| FROM linkedin_data_demo |
| WHERE data_id = 'santhosh-ramaswamy-505842118' |
| |
| |
| SELECT data_id, lang ->> 'name' |
| FROM linkedin_data_demo, |
| jsonb_array_elements(languages) AS lang |
| LIMIT 10 |