• Ivy Seo

Create Hyper-table

Language: C#


pre-requisite: Need a table to copy from


Code:

private static void Create_NewTable_HyperTable()
        {
            // connect to postgresql
            var cs = "Host=##; Username=##; Password=##; Database=##";
            using var con = new NpgsqlConnection(cs);
            con.Open();
            using var cmd = new NpgsqlCommand();
            cmd.Connection = con;
            // CREATE NEW TABLE and COPY from OLD TABLE
            cmd.CommandText = "CREATE TABLE New_Table (LIKE Original_Table INCLUDING DEFAULTS INCLUDING CONSTRAINTS INCLUDING INDEXES)";
            cmd.ExecuteNonQuery();
            cmd.CommandTimeout = 300;   // extended time out 
            // create hypertable and time for the dataset
            cmd.CommandText = "SELECT create_hypertable('New_Table', 'timestamp_')";
            cmd.ExecuteNonQuery();
            // INSERT QUERY : Insert data from old table
            cmd.CommandText = "INSERT INTO New_Table SELECT * FROM Original_Table;";
            cmd.ExecuteNonQuery();
        }

Recent Posts

See All

Generate unique filename: UUID, Path

A: using UUID let my_uuid = Uuid::new_v4(); let file_created = File::create(my_uuid.to_string()).expect("create file failed");     println!("uuid: {}", my_uuid); //  buffer write let mut file_ge

JSON - write .txt file in Rust

pub fn serialize_writeFile(data : &full_data ) -> Result<bool, modbus::Error> { // 1) takes data  // this function takes the m7_data object and serializes the contents and saves the results to a text

Serialize/Deserialize JSON in Rust

This README has some good examples. To deserialize in Rust: use serde::{Deserialize, Serialize}; use serde_json::Result; #[derive(Serialize, Deserialize)] struct Person {     name: String,     age: u