Re: [SQL] BACK UP

2000-06-10 Thread Poul L. Christiansen
Use the command "pg_dumpall" to dump all databases to disk in SQL format. I don't know if there is any function for taking a backup of the work done during the day. We just dump all databases every day, to make a backup. Poul L. Christiansen GANESH KUMAR wrote: > I WANT TO TAKE BACK UP DAILY W

Re: [SQL] postmaster: init.d/start

2000-06-10 Thread Daniel Fairs
This is the System V-style initialisation. The layout is as follows: /etc/rc.d/init.d/ This directory contains the actual scripts which start and stop the various services on the system. The system supplies a 'start' or 'stop' parameter for the call of the script depending on whether the system

[SQL] BACK UP

2000-06-10 Thread GANESH KUMAR
I WANT TO TAKE BACK UP DAILY WORK DONE WHAT IS PROCEDURE IS THERE ANY COMMMAND GANESH __ Do You Yahoo!? Yahoo! Photos -- now, 100 FREE prints! http://photos.yahoo.com

[SQL] postmaster: init.d/start

2000-06-10 Thread Markus Wagner
Hi, under SuSe Linux 6.3 there are different subdirectories rc.d for different runlevels. Each dir contains links to the start/stop scripts. The filenames contain numbers to indicate the position / the order of the services to start. Where (for which runlevel) and at what position should I link

Re: [SQL] AUTO INCREMENT

2000-06-10 Thread Lucile Dirry
Check manual/user for details on 'sequences'. Good luck. -Message d'origine- De : [EMAIL PROTECTED] <[EMAIL PROTECTED]> À : GANESH KUMAR <[EMAIL PROTECTED]> Cc : [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date : samedi 10 juin 2000 12:12 Objet : Re: [SQL] AUTO INCREMENT >On Sat, 10 Jun 2000,

Re: [SQL] AUTO INCREMENT

2000-06-10 Thread M . Mazurek
On Sat, 10 Jun 2000, GANESH KUMAR wrote: > i am searching for > autoincrement in table > > in table employee > i want give empno as autoincrement create table xyz (id serial primary key); check documentation what it really is:). Marcin Mazurek -- administrator MULTINET SA o/Poznan http://ww

[SQL] AUTO INCREMENT

2000-06-10 Thread GANESH KUMAR
i am searching for autoincrement in table in table employee i want give empno as autoincrement is there any syntax like this create table emp (empno integer auto_increment); send reply ganesh __ Do You Yahoo!? Yahoo! Photos -- now, 100 FREE