Can you add two columns to the table creation definition, one with a
default current timestamp, the second to be updated with current time in
an on update trigger. Then perhaps you could do something like
SELECT
min(new_insert_timestamp_column),
max(new_update_timestamp_column) FROM
to dump a PostgreSQL database, producing
# compressed tar file containing with pg_dump output.
# Author: Berend M. Tober btober-at-computer-dot-org
# Date: August 25, 2003
if [ ${1} = ]
then
echo Must specify database name
exit 0
fi
# setup variables
NAIL=/usr/local/bin/nail
PG_DUMP=/usr
How to Create auto_increment field in PostreSQL.
Its called the SERIAL datatype:
create table test_table (
field1 serial,
constraint test_table_pkey primary key (field1));
Can I create them using Trigger.
Yes, alternatively, but I'm told that is not recommended because the
server source
I need to manually keep a sequence for each row of the employee table,
i.e., I don't want to use postgres's built-in sequences for this
application because the sequence numbers are used to generate expense
report numbers on a per-employee basis. That is, each employee has a
separate sequence
What I need to know is whether or not this is multi-user safe, i.e.,
will the block of code in the procedure execute as a transaction so
that if more than one clerk creates an expense report for the same
employee simultaneously is it possible or impossible that value of
the
Dnia 2003-06-19 19:50, U¿ytkownik murali napisa³:
I' would like to connect my postgres database on a linux server with
Delphi 5 Applications,which are located on Win95/98 Clients, very
helpful would be an example on how to realize a connection of these
things
Am Sonntag, 22. Juni 2003 14:45 schrieb [EMAIL PROTECTED]:
I have not used column check constraints before, but I'd like to
start using then and so would I'll like to know if there is a direct
way to provide feedback to the end user about data validation rules
expressed in column check
I have not used column check constraints before, but I'd like to start
using then and so would I'll like to know if there is a direct way to
provide feedback to the end user about data validation rules expressed in
column check constraints?
For instance, say that I wanted to use a RE to check