PostgreSQL ​

Connect ​

GreptimeDB also supports PostgreSQL server protocol! To get started, simply add the -U argument to your command, followed by your username and password. Here's an example:

❯ psql -h localhost -p 4003 -U greptime_user -d public
Password for user greptime_user:
psql (15.2, server 0.1.1)
WARNING: psql major version 15, server major version 0.1.
         Some psql features might not work.
Type "help" for help.

public=>

❯ psql -h localhost -p 4003 -U greptime_user -d public
Password for user greptime_user:
psql (15.2, server 0.1.1)
WARNING: psql major version 15, server major version 0.1.
         Some psql features might not work.
Type "help" for help.

public=>

Note: Be sure to replace greptime_user(username) and greptime_pwd(password) with your own username and password.

HTTP API ​

GreptimeDB supports sending SQL statements through HTTP API. For information on how to set up authentication, please refer to HTTP API.

Write data ​

Please refer to SQL.

Query data ​

Please refer to SQL.

Time zone ​

GreptimeDB's PostgreSQL protocol interface follows original PostgreSQL on datatype-timezones.

By default, PostgreSQL uses its server time zone for timestamp. To override, you can set time_zone variable for current session using SQL statement SET TIMEZONE TO '<value>';. The value of time_zone can be any of:

• A full time zone name, for example America/New_York.
• A time zone abbreviation, for example PST.
• Offset to UTC such as +08:00.

You can use SHOW to check the current time zone settings. For example:

SHOW VARIABLES time_zone;

SHOW VARIABLES time_zone;

 TIME_ZONE 
-----------
 UTC

 TIME_ZONE 
-----------
 UTC

Change the session time zone to +1:00:

SET TIMEZONE TO '+1:00'

SET TIMEZONE TO '+1:00'

For information on how the time zone affects data inserts and queries, please refer to the SQL documents in the write data and query data sections.