Re: [SQL] Table definition

2004-11-16 Thread Goutam Paruchuri
Title: Les consultants Interaction | stationery Probably there is no direct way get the definition (i could not find one atleast). You can probably write a custom function which gives all columns, indexes and formulate a create table statement (text definition).   Let us know if you find a wa

Re: [SQL] [GENERAL] how to use COPY within plperl

2004-11-13 Thread Goutam Paruchuri
Why can you not use simple insert statements (sql insert). Copy is meant to transfer large amount of data from text files to databases and vice versa. - Goutam > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Marek Lewczuk > Sent: Monday, Novembe

Re: [SQL] Error In connection ??

2004-11-10 Thread Goutam Paruchuri
; To: Goutam Paruchuri > Cc: [EMAIL PROTECTED] > Subject: Re: [SQL] Error In connection ?? > > > Goutam Paruchuri wrote: > > My understanding was it means ip range of 1 to 254. > > > > 192.168.2.1 to 192.168.1.254 > > No, it refers to the number of bits. Yo

Re: [SQL] Error In connection ??

2004-11-10 Thread Goutam Paruchuri
The IP of the client machine aim connecting from is 192.168.2.123 Which is greater than 32. Thanks ! - Goutam > -Original Message- > From: Richard Huxton [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 10, 2004 12:19 PM > To: Goutam Paruchuri > Cc: [EMAIL PROTE

Re: [SQL] Error In connection ??

2004-11-10 Thread Goutam Paruchuri
My understanding was it means ip range of 1 to 254. 192.168.2.1 to 192.168.1.254 > -Original Message- > From: Richard Huxton [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 10, 2004 12:19 PM > To: Goutam Paruchuri > Cc: [EMAIL PROTECTED] > Subject:

[SQL] Error In connection ??

2004-11-10 Thread Goutam Paruchuri
Hello, I get an error in my log when connecting to postgres server on Windows. Postgres version : 8.0.0-beta4 LOG TEXT 2004-11-10 11:22:47 LOG: invalid entry in file "C:/Program Files/PostgreSQL/8.0.0-beta4/data/pg_hba.conf" at line 64, token "192.168.2.1/254" 2004-11-10 11:22:47 FATAL: missi

[SQL] Loading text data/binary data !!

2004-11-09 Thread Goutam Paruchuri
Hello all,    2 questions !   Question 1 Iam trying to load binary data from sql server to postges.  Do i have to write a script .. ??   Question 2 How i do load text data with newlines into postgres database .. (as newline is the default row delimiter and cannot be changed in the column