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
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
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:
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
; 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
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
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
