Isabelle Brette wrote:
>
> Hello,
>
> On Thu, Jan 03, 2002 at 12:10:01PM -0500, Zhang, Anna wrote:
> > I have a problem to load data to postgres database using copy command. The
> > problem is that we have one column called address which is multi-line text,
> > the taxt file looks like this:
>
Hello,
On Thu, Jan 03, 2002 at 12:10:01PM -0500, Zhang, Anna wrote:
> I have a problem to load data to postgres database using copy command. The
> problem is that we have one column called address which is multi-line text,
> the taxt file looks like this:
>
> aab770|awkc.com administration|sult
I have a problem to load data to postgres database using copy command. The
problem is that we have one column called address which is multi-line text,
the taxt file looks like this:
aab770|awkc.com administration|sultan 23
Bogota, na0|CO
above shows one record with '|' as delimiters. Column
Marc <[EMAIL PROTECTED]> writes:
> can someone tell me what's the usetrace column for in the pg_user and
> pg_shadow table/view ?
AFAIK it's not used at all anymore. Probably it did something back
in the Berkeley days ...
regards, tom lane
---(en
I think this may have been answered earlier do to mailing list oddities, but
just in case:
Change this:
#tcpip_socket = false
to this:
tcpip_socket = true
You may also need to make some changes in pg_hba.conf to authorize the
connection from a particular host. Although this page is aimed at J
I think this may have been answered earlier due to mailing list oddities,
but
just in case:
Change this:
#tcpip_socket = false
to this:
tcpip_socket = true
You may also need to make some changes in pg_hba.conf to authorize the
connection from a particular host. Although this page is aimed at
tcpip_socket=1 worked for us...
- Original Message -
From: "Marc" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 31, 2001 6:24 AM
Subject: [ADMIN] Allowing TCP/IP connections
> In the postgres configuration file, which options do I have to enable to
> allow TCP/IP
Hi ,
We are facing some problems with the creation of tables of same name but
owned by different user .
We followed the following steps .
Lets say, we have a database DBTest and this database was created by the
user postgres.
We created tables - Table1, Table2 and Table3 in it.
Now, by using t
Hi,
can someone tell me what's the usetrace column for in the pg_user and
pg_shadow table/view ?
Regards
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
In the postgres configuration file, which options do I have to enable to
allow TCP/IP connections:
#
# Connection Parameters
#
#tcpip_socket = false
#ssl = false
#max_connections = 32 # 1-1024
#port = 5432
#hostname_lookup = false
#show_source_port = false
#unix_socket_directory = ''
#un
When you compile the postgres, you can make it so that other progs can find
the included when you need them to by putting the $PGSQL/lib in
/etc/ld.so.conf and running /sbin/ldconfig
You can always specify where the includes and libs are in php using
the --with-pgsql=$PGSQL
-James
-Original
On Fri, 21 Dec 2001 13:41:43 -0800, David Larsen
<[EMAIL PROTECTED]> wrote:
>I am running PostgreSQL 7.0.3 on RedHat 7.1. I would like to create
>databases in /u1/psql/data, and can't get it to work. I defined
>PGDATA2=/u1/psql/data and exported it in my .bash_profile for
>postgres user. I even
12 matches
Mail list logo
