No getdate() function in EnterpriseDB PostgreSQL

postgresql enterprisedb
Suezy picture Suezy · May 21, 2010 · Viewed 31.4k times · Source

Do you have any idea on how to have a getdate() function in EnterpriseDB PostgreSQL? I upgraded to EDB-PSQL, and when I try to restore old data from the free PSQL, it returns error on some tables since there is no getdate().

I believe this should automatically be created upon creating new database? But it didn't. :( Only a now() function.

Can I create the function instead? Help!

Answer

araqnid picture araqnid · May 21, 2010

If getdate() is like now() (as with SQL Server) you can simply say

create function public.getdate() returns timestamptz
       stable language sql as 'select now()';

Related questions

Alter column set not null fails

Consider the following table with approximately 10M rows CREATE TABLE user ( id bigint NOT NULL, ... CONSTRAINT user_pk PRIMARY KEY (id) ) WITH ( OIDS=FALSE ) Then i applied the following alter ALTER TABLE USER ADD COLUMN BUSINESS_ID VARCHAR2(50); --OK UPDATE …

Read More
SCRAM authentication requires libpq version 10 or above in

I get an error when I try to connect to the Postgresql server with PHP, and I get an error like this one: Unable to connect to PostgreSQL server: SCRAM authentication requires libpq version 10 or above in I use EnterpriseDb, …

Read More
List Partition in Postgres

I'm using Enterprise Postgres with Oracle Compatibilty. Here is a table I have created in my database. CREATE TABLE ALL_COUNTRIES ( COUNTRY_ID numeric(20,0), CHARACTERISTIC_NAME character varying(255) ) PARTITION BY LIST (COUNTRY_ID) ( PARTITION COUNTRY VALUES (484, 170, 76, 360, 710) TABLESPACE my_tbs ); Two …

Read More