Re(2): [ADMIN] Copying a Database

a followup to my reply... you can try 'copy'. database=# \h copy Command: COPY Description: Copies data between files and tables Syntax: COPY [ BINARY ] table [ WITH OIDS ] FROM { 'filename' | stdin } [ [USING] DELIMITERS 'delimiter' ] [ WITH NULL AS 'null string' ] COPY [ BINARY

Re: [ADMIN] Copying a Database

[EMAIL PROTECTED] writes: >Is there an SQL command to inherit an entire database. > >Sean. AFAIK, there is none but you can use 'pg_dump'. Sherwin

[ADMIN] Copying a Database

Is there an SQL command to inherit an entire database.   Sean.

RE: [ADMIN] SQL statement limit

I was unclear on this, although I think the answer below is correct for my real question. Let me ask this question again... What is the current size limit for a single row (say for type TEXT or VARCHAR)? When is this expected to go away (7.1?)? Is the info below accurate? Am I limited to 32k (if

[ADMIN] help

Help me for "DBI->connect failed: Sorry, too many clients already."my cgi program is test.cgi:###require "./connectdb.pl";&connectdatabase();$query="select count(*) from messages";$sth=$dbh->prepare($query);$sth->execute();$count=$sth->fetchrow_array();print "Content-typ

[ADMIN] Help me for "DBI->connect failed: Sorry, too many clients already."

my cgi program is test.cgi:###require "./connectdb.pl";&connectdatabase();$query="select count(*) from messages";$sth=$dbh->prepare($query);$sth->execute();$count=$sth->fetchrow_array();print "Content-type: text/html\n\n";print <<"TAG"; The count is $count. TAGexit 0;#

[ADMIN] Large Object

Hi! , I want to ask you about large objects or BLOBs   I need to know the size of a large object that I have already know its indice number.   For example ,   One of my large objects in my database  is indicated with xinv223345 and xinc223345   if I use this command   select lo_export(22334

Re: [ADMIN] SQL statement limit

If I understand your question, you can change this limit, but not to 200k. By default, the data limit in a field record is 8k in the PostgreSQL 7.0x series. You can make it 16k or 32k. Go into the src/include subdir of whatever directory you extracted the tarball into. Before compiling, edit th

[ADMIN] Dump a base from PostgreSQL 6.5.3 to PostgreSQL 7.0

When I want to dump from pg6.5.3 and restore in pg7.0 I don't get the index's with me. They are in pg6.5.3 and in thedump-script. If I use the pg_dumpall from pg7.0 to dump the base in pg6.5.3 and then restore it in pg7.0 the index's aren't showed. What could be wrong here? Is there more versio

[ADMIN] SQL statement limit

Hi all, We have a pretty significant problem with the current 4k (or is it 8k) limit in length of a single SQL statement. I remember reading somewhere that this limit has been (will be) completely removed in 7.1 but I'd like to verify this. Also if anyone has a reasonable guess to 7.1's r