Skip to main content ↑ ↓

User

Welcome, Guest. Please login.

Login with username, password and session length

Online

15 Guests, 0 Users

Recent

Pages: 1 [2]

Create new table with structure of another but no data

Posted in PostgreSQL
February 26, 2017, 06:50:42 pm
Written by tino
Views: 4059
Code: [Select]
CREATE TABLE new_table AS SELECT * FROM old_table WHERE 1=2;

0 Comments

timestamp round function

Posted in PostgreSQL
February 26, 2017, 06:50:11 pm
Written by tino
Views: 3996
Code: [Select]
CREATE FUNCTION ts_round( timestamptz, INT4 ) RETURNS TIMESTAMPTZ AS $$
    SELECT 'epoch'::timestamptz + '1 second'::INTERVAL * ( $2 * ( extract( epoch FROM $1 )::INT4 / $2 ) );
$$ LANGUAGE SQL;
...

Read More

0 Comments

PostgreSQL upgrade instructions

Posted in PostgreSQL
February 26, 2017, 06:49:51 pm
Written by tino
Views: 4506

Download the new postgresql version

untar , then

Code: [Select]
 
./configure 
make

Stop the old server
Code: [Select]
sudo /usr/local/pgsql/bin/pgsql.sh stop

Move the old server directory

Code: [Select]
mv /usr/local/pgsql /usr/local/pgsql-9.1.24

Now install the new server

Code: [Select]
make install

cd into the...

Read More

0 Comments

WatchDog Timer

Posted in C Code
February 26, 2017, 06:48:37 pm
Written by tino
Views: 4468
Code: [Select]
#include #include #include 
/*

 Watchdog Timer Prescale Select
 
 WDP3   WDP2 WDP1 WDP0   Number of WDT     Typical Time-out at Oscillator Cycles     VCC = 5.0V
 
 0    0    0      0             2K (2048) cycles       16 ms
 0    0    0      1             4K (4096) cycles       32 ms
 0    0
...

Read More

0 Comments
Pages: 1 [2]