Re: [ADMIN] How to use psql -c?

2003-12-30 Thread Hans Peter Wiedau
On Mon, Dec 29, 2003 at 02:37:57PM -0700, Charles Haron wrote: > The following command works as I want: > psql -c "DELETE FROM prg_dates_members WHERE confirm = 'f';" comfire > > I want to be able to run the above command as a cron job. I created a > script with the following command, but I get

[ADMIN] remote access to linux

2003-12-30 Thread vidhya
Hi,   I want to access the Linux server in US from win2k in India.   Do you have any service like terminal services client to access the Linux server.   Thank u,   Regards,   Vidhya.

[ADMIN] remote access to linux

2003-12-30 Thread vidhya
Hi,   I want to access the Linux server in US from win2k in India.   Do you have any service like terminal services client to access the Linux server.   Thank u,   Regards,   Vidhya.

Re: [ADMIN] remote access to linux

2003-12-30 Thread pginfo
Hi, use ssh if you need only terminal or vnc if you will need X. regards, ivan. vidhya wrote:   Hi, I want to access the Linux server in US from win2k in India. Do you have any service like terminal services client to access the Linux server. Thank u, Regards, Vidhya.  

[ADMIN] drop column

2003-12-30 Thread Ashok Chauhan
hello i have a problem to drop a column. on postgresql site (link) http://www.postgresql.org/docs/current/interactive/ddl-alter.html#AEN2124 A command for remove the column but it not work it gives parse error ALTER TABLE tablename DROP COLUMN fieldname; plz. help me Ashok --

Re: [ADMIN] remote access to linux

2003-12-30 Thread Ericson Smith
Yes, look into http://www.realvnc.com/what.html Don't forget SSH console access as well. Regards - Ericson vidhya wrote: Hi, I want to access the Linux server in US from win2k in India. Do you have any service like terminal services client to access the Linux server. Thank u, Regards,

Re: [ADMIN] drop column

2003-12-30 Thread A.Bhuvaneswaran
> A command for remove the column but it not work > it gives parse error > ALTER TABLE tablename DROP COLUMN fieldname; drop column feature is implemented since 7.3. So, you please check out your version. regards, bhuvaneswaran signature.asc Description: This is a digitally signed message part

Re: [ADMIN] How to use psql -c?

2003-12-30 Thread Charles Haron
On Dec 30, 2003, at 3:07 AM, Hans Peter Wiedau wrote: On Mon, Dec 29, 2003 at 02:37:57PM -0700, Charles Haron wrote: The following command works as I want: psql -c "DELETE FROM prg_dates_members WHERE confirm = 'f';" comfire I want to be able to run the above command as a cron job. I created a s

[ADMIN] service postgresql start Fails, Can't su

2003-12-30 Thread Phillip Harrington
Hello, [EMAIL PROTECTED] root]# service postgresql start Starting postgresql service: Password: su: incorrect password [FAILED] I've tried this as the postgres user as well and get: [EMAIL PROTECTED] root]# su postgres Password: bash-2.05

[ADMIN] ftp postgres database from windows 2000 to Linux

2003-12-30 Thread vidhya
HI,   I have my postgres databases on win2k under cygwin.   Tell me the steps to transfer those databases to linux?   Regards, vidhya

Re: [ADMIN] ftp postgres database from windows 2000 to Linux

2003-12-30 Thread Steve Crawford
On Tuesday 30 December 2003 8:21 pm, vidhya wrote: > HI, > > I have my postgres databases on win2k under cygwin. > > Tell me the steps to transfer those databases to linux? I haven't used pg under cygwin but pg_dump and pg_dumpall are the standard ways to dump databases. The output is plain text

[ADMIN] Fw: FTP

2003-12-30 Thread vidhya
  - Original Message - From: Baskaran Vidhya To: [EMAIL PROTECTED] Sent: Wednesday, December 31, 2003 10:49 AM Subject: FTP hi,   How to ftp postgres database from windows 2000 to linux?   Vidhya.

Re: [ADMIN] drop column

2003-12-30 Thread Ashok Chauhan
On Tue, 2003-12-30 at 14:04, A.Bhuvaneswaran wrote: > > A command for remove the column but it not work > > it gives parse error > > ALTER TABLE tablename DROP COLUMN fieldname; > > drop column feature is implemented since 7.3. So, you please check out > your version. > > regards, > bhuvaneswaran