Langsung ke konten utama
Area teknologi
close
AI dan ML
Pengembangan aplikasi
Hosting aplikasi
Compute
Pipeline dan analisis data
Database
Terdistribusi, hybrid, dan multicloud
Solusi industri
Migrasi
Jaringan
Kemampuan observasi dan pemantauan
Keamanan
Storage
Alat cross product
close
Pengelolaan akses dan resource
Pengelolaan biaya dan penggunaan
Infrastruktur sebagai kode
SDK, bahasa, framework, dan alat
/
Konsol
English
Deutsch
Español
Español – América Latina
Français
Indonesia
Italiano
Português
Português – Brasil
עברית
中文 – 简体
中文 – 繁體
日本語
한국어
Masuk
Spanner
Mulai gratis
Ringkasan
Panduan
Referensi
Contoh
Dukungan
Referensi
Area teknologi
Lainnya
Ringkasan
Panduan
Referensi
Contoh
Dukungan
Referensi
Alat cross product
Lainnya
Konsol
Spanner
Semua API & referensi
Ringkasan API dan library klien
Library klien dan driver
Library klien
Ringkasan
Referensi C++
Referensi C#
Referensi Go
Referensi Java
Referensi Node.js
Referensi PHP
Referensi Python
Referensi Ruby
Driver
Ringkasan driver
Driver JDBC
Ringkasan
Menghubungkan JDBC ke database dialek GoogleSQL
Menghubungkan JDBC ke database dialek PostgreSQL
Perintah pengelolaan sesi
Untuk database dialek GoogleSQL
Untuk database dialek PostgreSQL
Driver JDBC Spanner
Driver R2DBC
Driver database/sql Go
Driver pgx untuk Golang
Driver ADO.NET
Driver psycopg2 untuk Python
Driver psycopg3 untuk Python
Driver node-postgres untuk Node.js
Spanner API
Referensi REST
Ringkasan
Parameter API standar
Endpoint layanan global dan regional
v1
Resource REST
projects.instanceConfigOperations
Ringkasan
list
projects.instanceConfigs
Ringkasan
create
delete
get
list
patch
projects.instanceConfigs.operations
Ringkasan
cancel
delete
get
list
project.instances
Ringkasan
create
delete
get
getIamPolicy
list
move
patch
setIamPolicy
testIamPermissions
projects.instances.backupOperations
Ringkasan
list
projects.instances.backups
Ringkasan
salin
create
delete
get
getIamPolicy
list
patch
setIamPolicy
testIamPermissions
projects.instances.backups.operations
Ringkasan
cancel
delete
get
list
projects.instances.databaseOperations
Ringkasan
list
projects.instances.databases
Ringkasan
addSplitPoints
changequorum
create
dropDatabase
get
getDdl
getIamPolicy
list
patch
pulihkan
setIamPolicy
testIamPermissions
updateDdl
projects.instances.databases.backupSchedules
Ringkasan
create
delete
get
getIamPolicy
list
patch
setIamPolicy
testIamPermissions
projects.instances.databases.databaseRoles
Ringkasan
list
testIamPermissions
projects.instances.databases.operations
Ringkasan
cancel
delete
get
list
projects.instances.databases.sessions
Ringkasan
adaptMessage
adaptor
batchCreate
batchWrite
beginTransaction
commit
create
delete
executeBatchDml
executeSql
executeStreamingSql
get
list
partitionQuery
partitionRead
baca
rollback
streamingRead
projects.instances.instancePartitionOperations
Ringkasan
list
projects.instances.instancePartitions
Ringkasan
create
delete
get
list
patch
projects.instances.instancePartitions.operations
Ringkasan
cancel
delete
get
list
projects.instances.operations
Ringkasan
cancel
delete
get
list
Types
AutoscalingConfig
ChangeQuorumMetadata
Kode
CompactDatabaseMetadata
CopyBackupMetadata
CreateBackupMetadata
CreateDatabaseMetadata
CreateInstanceConfigMetadata
CreateInstanceMetadata
CreateInstancePartitionMetadata
DatabaseDialect
DdlStatementActionInfo
DirectedReadOptions
Edisi
EncryptionInfo
ErrorInfo
FulfillmentPeriod
GetPolicyOptions
Bantuan
KeySet
ListOperationsResponse
MoveInstanceMetadata
MoveInstanceResponse
MultiplexedSessionPrecommitToken
Mutasi
OperationProgress
OptimizeRestoredDatabaseMetadata
PartialResultSet
PartitionOptions
PartitionResponse
Kebijakan
QueryMode
QueryOptions
ReplicaSelection
RequestOptions
RestoreDatabaseMetadata
ResultSet
ResultSetMetadata
ResultSetStats
Status
StructType
TestIamPermissionsResponse
Transaksi
TransactionOptions
TransactionSelector
Jenis
UpdateDatabaseDdlMetadata
UpdateDatabaseMetadata
UpdateInstanceConfigMetadata
UpdateInstanceMetadata
UpdateInstancePartitionMetadata
WaitOperationRequest
Referensi RPC
Ringkasan
google.iam.v1
google.longrunning
google.rpc
google.spanner.adapter.v1
google.spanner.admin.database.v1
google.spanner.admin.instance.v1
google.spanner.v1
google.type
Referensi MCP
Ringkasan
Server Spanner
Ringkasan
Alat
get_instance
list_instances
list_configs
get_config
create_instance
update_instance
create_database
get_database_ddl
list_databases
create_session
execute_sql
execute_sql_readonly
commit
update_database_schema
get_operation
Server insight database
Ringkasan
Alat
get_system_metrics
SQL di Spanner
Referensi cepat sintaksis SQL
Paritas dialek antara GoogleSQL dan PostgreSQL
GoogleSQL
Referensi umum
Ringkasan GoogleSQL
Jenis data
Struktur dan sintaksis leksikal
Aturan konversi
Kolasi
Elemen format
Volatilitas fungsi
Prosedur tersimpan
Persamaan
Panggilan fungsi
Panggilan fungsi agregat
Operator
Ekspresi bersyarat
Subkueri
Sintaksis kueri
Fungsi
Semua fungsi
Fungsi agregat
Ringkasan
ANY_VALUE
ARRAY_AGG
ARRAY_CONCAT_AGG
AVG
BIT_AND
BIT_OR
BIT_XOR
COUNT
COUNTIF
LOGICAL_AND
LOGICAL_OR
MAKS
MIN
STRING_AGG
SUM
Fungsi array
Ringkasan
ARRAY
ARRAY_CONCAT
ARRAY_FILTER
ARRAY_FIRST
ARRAY_INCLUDES
ARRAY_INCLUDES_ALL
ARRAY_INCLUDES_ANY
ARRAY_IS_DISTINCT
ARRAY_LAST
ARRAY_LENGTH
ARRAY_MAX
ARRAY_MIN
ARRAY_REVERSE
ARRAY_SLICE
ARRAY_TO_STRING
ARRAY_TRANSFORM
GENERATE_ARRAY
GENERATE_DATE_ARRAY
JSON_ARRAY
JSON_QUERY_ARRAY
JSON_VALUE_ARRAY
Fungsi bit
Ringkasan
BIT_COUNT
BIT_REVERSE
Fungsi kompresi
Ringkasan
ZSTD_COMPRESS
ZSTD_DECOMPRESS_TO_BYTES
ZSTD_DECOMPRESS_TO_STRING
Fungsi konversi
Ringkasan
CAST
SAFE_CAST
Fungsi tanggal
Ringkasan
ADDDATE
CURRENT_DATE
DATE
DATE_ADD
DATE_DIFF
DATE_FROM_UNIX_DATE
DATE_SUB
DATE_TRUNC
EXTRACT (date)
FORMAT_DATE
PARSE_DATE
SUBDATE
UNIX_DATE
Fungsi proses debug
Ringkasan
KESALAHAN
Fungsi grafik
Ringkasan
DESTINATION_NODE_ID
TEPI
ELEMENT_DEFINITION_NAME
ELEMENT_ID
IS_ACYCLIC
IS_FIRST
IS_TRAIL
LABEL
NODE
PATH
PATH_FIRST
PATH_LAST
PATH_LENGTH
PROPERTY_NAMES
SOURCE_NODE_ID
Fungsi hash
Ringkasan
FARM_FINGERPRINT
SHA1
SHA256
SHA512
Fungsi interval
Ringkasan
EXTRACT (interval)
JUSTIFY_DAYS
JUSTIFY_HOURS
JUSTIFY_INTERVAL
MAKE_INTERVAL
Fungsi JSON
Ringkasan
BOOL
BOOL_ARRAY
FLOAT64
FLOAT64_ARRAY
FLOAT32
FLOAT32_ARRAY
INT64
INT64_ARRAY
JSON_ARRAY
JSON_ARRAY_APPEND
JSON_ARRAY_INSERT
JSON_CONTAINS
JSON_OBJECT
JSON_QUERY
JSON_QUERY_ARRAY
JSON_REMOVE
JSON_SET
JSON_STRIP_NULLS
JSON_TYPE
JSON_VALUE
JSON_VALUE_ARRAY
LAX_BOOL
LAX_FLOAT64
LAX_INT64
LAX_STRING
PARSE_JSON
SAFE_TO_JSON
STRING (JSON)
STRING_ARRAY
TO_JSON
TO_JSON_STRING
Fungsi machine learning dan AI
Ringkasan
AI.CLASSIFY
AI.IF
AI.SCORE
ML.PREDICT
Fungsi matematika
Ringkasan
ABS
ACOS
ACOSH
APPROX_COSINE_DISTANCE
APPROX_DOT_PRODUCT
APPROX_EUCLIDEAN_DISTANCE
ASIN
ASINH
ATAN
ATAN2
ATANH
CEIL
CEILING
COS
COSH
COSINE_DISTANCE
DIV
DOT_PRODUCT
EXP
EUCLIDEAN_DISTANCE
FLOOR
TERBAIK
IEEE_DIVIDE
IS_INF
IS_NAN
PALING SEDIKIT
LN
LOG
LOG10
MOD
POW
DAYA
ROUND
SAFE_ADD
SAFE_DIVIDE
SAFE_MULTIPLY
SAFE_NEGATE
SAFE_SUBTRACT
TANDA
SIN
SINH
SQRT
TAN
TANH
TRUNC
Fungsi net
Ringkasan
NET.HOST
NET.IP_FROM_STRING
NET.IP_NET_MASK
NET.IP_TO_STRING
NET.IP_TRUNC
NET.IPV4_FROM_INT64
NET.IPV4_TO_INT64
NET.PUBLIC_SUFFIX
NET.REG_DOMAIN
NET.SAFE_IP_FROM_STRING
Fungsi buffering protokol
Ringkasan
REPLACE_FIELDS
Fungsi penelusuran
Ringkasan
DEBUG_TOKENLIST
SKOR
SCORE_NGRAMS
TELUSURI
SEARCH_NGRAMS
SEARCH_SUBSTRING
SNIPPET
TOKEN
TOKENIZE_BOOL
TOKENIZE_FULLTEXT
TOKENIZE_JSON
TOKENIZE_NGRAMS
TOKENIZE_NUMBER
TOKENIZE_SUBSTRING
TOKENLIST_CONCAT
Fungsi urutan
Ringkasan
GET_INTERNAL_SEQUENCE_STATE
GET_NEXT_SEQUENCE_VALUE
Fungsi agregat statistik
Ringkasan
STDDEV
STDDEV_SAMP
VAR_SAMP
VARIANCE
Fungsi string
Ringkasan
BYTE_LENGTH
CHAR_LENGTH
CHARACTER_LENGTH
CODE_POINTS_TO_BYTES
CODE_POINTS_TO_STRING
CONCAT
ENDS_WITH
FORMAT
FROM_BASE32
FROM_BASE64
FROM_HEX
LCASE
LENGTH
LEBIH RENDAH
LPAD
LTRIM
NORMALIZE
NORMALIZE_AND_CASEFOLD
OCTET_LENGTH
REGEXP_CONTAINS
REGEXP_EXTRACT
REGEXP_EXTRACT_ALL
REGEXP_REPLACE
ULANGI
GANTI
REVERSE
RPAD
RTRIM
SAFE_CONVERT_BYTES_TO_STRING
SOUNDEX
SPLIT
SPLIT_SUBSTR
STARTS_WITH
STRPOS
SUBSTR
SUBSTRING
TO_BASE32
TO_BASE64
TO_CODE_POINTS
TO_HEX
TRIM
UPPER
UCASE
Fungsi stempel waktu
Ringkasan
CURRENT_TIMESTAMP
EXTRACT (stempel waktu)
FORMAT_TIMESTAMP
PARSE_TIMESTAMP
PENDING_COMMIT_TIMESTAMP
STRING (stempel waktu)
TIMESTAMP
TIMESTAMP_ADD
TIMESTAMP_DIFF
TIMESTAMP_MICROS
TIMESTAMP_MILLIS
TIMESTAMP_SECONDS
TIMESTAMP_SUB
TIMESTAMP_TRUNC
UNIX_MICROS
UNIX_MILLIS
UNIX_SECONDS
Fungsi utilitas
Ringkasan
GENERATE_UUID
Fungsi MySQL
Semua fungsi MySQL
Fungsi tanggal dan waktu
Ringkasan
DATE_FORMAT
HARI
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
FROM_DAYS
FROM_UNIXTIME
HOUR
MAKEDATE
MIKRODETIK
MENIT
BULAN
MONTHNAME
PERIOD_ADD
PERIOD_DIFF
KUARTAL
KEDUA
STR_TO_DATE
SYSDATE
WAKTU
TO_DAYS
TO_SECONDS
UNIX_TIMESTAMP
UTC_DATE
UTC_TIMESTAMP
MINGGU
WEEKDAY
WEEKOFYEAR
YEAR
Fungsi enkripsi dan kompresi
Ringkasan
SHA2
Fungsi JSON
Ringkasan
JSON_QUOTE
JSON_UNQUOTE
Fungsi numerik
Ringkasan
DEGREES
LOG2
PI
RADIANS
TRUNCATE
Fungsi string
Ringkasan
BIT_LENGTH
CHAR
CONCAT_WS
HEX
INSERT
TEMUKAN
MID
OKT
ORD
POSISI
PENAWARAN HARGA
REGEXP_LIKE
REGEXP_SUBSTR
SPACE
STRCMP
SUBSTRING_INDEX
UNHEX
Fungsi stempel waktu
Ringkasan
DATEDIFF
LOCALTIME
LOCALTIMESTAMP
SEKARANG
Fungsi utilitas
Ringkasan
BIN_TO_UUID
INET_ATON
INET_NTOA
INET6_ATON
INET6_NTOA
IS_IPV4
IS_IPV4_COMPAT
IS_IPV4_MAPPED
IS_IPV6
IS_UUID
UUID
UUID_TO_BIN
Pernyataan
DDL (Bahasa Definisi Data)
DML (Bahasa Pengolahan Data)
Bahasa prosedur
PostgreSQL
Ringkasan PostgreSQL
Struktur dan sintaksis leksikal
Definisi data (DDL)
Manipulasi data (DML)
Sintaksis kueri
Subkueri
Jenis data
Fungsi
Operator
Prosedur tersimpan
Tabel katalog sistem PostgreSQL
Tampilan katalog sistem PostgreSQL
Masalah umum di antarmuka PostgreSQL
Skema informasi
Untuk database GoogleSQL
Untuk database PostgreSQL
Operator eksekusi kueri
Ringkasan
Operator daun
Operator uner
Operator biner
Operator n-ary
Operator terdistribusi
Subkueri skalar
Subkueri array
Konstruktor struct
GQL di Spanner
Ringkasan
Spanner Graph dan standar ISO
Pernyataan skema
Ringkasan
Pernyataan CREATE PROPERTY GRAPH
Pernyataan DROP PROPERTY GRAPH
Pernyataan kueri
Ringkasan
Sintaksis GQL
Klausul grafik
Pernyataan CALL
