iles from the
archive to those in pg_xlog. Therefore, it will use the finished
versions and ignore the files copied from pg_xlog.
--
Christian
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
there corresponding to its system environment.
--
Christian
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
us.
You should be able to use PAM authentication, but you will have to
duplicate the users/groups in the database as well because PostgreSQL
does not refer to the system's user accounts.
If you want to create users in only one place, that must be the database.
--
Christian
--
Sent
CONSTRAINTS '
|| ' INCLUDING INDEXES) '
|| ' TABLESPACE '|| quote_ident(table_tablespace(p_old))
|| ';';
RETURN p_new::regclass;
END;
$$;
test=> SELECT create_table_like('data_prototype', 'data_20130226');
create_table_like
you are looking for.
Greetings
Christian
--
Christian Kratzer CK Software GmbH
Email: c...@cksoft.de Wildberger Weg 24/2
Phone: +49 7032 893 997 - 0 D-71126 Gaeufelden
Fax: +49 7032 893 997 - 9 HRB 245288, Amtsgericht Stuttgart
Web
for
maintaining such tables?
For one thing, with multiple databases you cannot easily take consistent
backups using pg_dump, because a transaction is local to a single database.
--
Christian
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your
* Bruce Momjian wrote:
On Thu, Sep 13, 2012 at 02:15:00PM +0200, Christian Ullrich wrote:
c:\Daten>path
PATH=c:\windows;c:\windows\system32;c:\Program Files\PostgreSQL\9.2\bin
c:\Daten>pg_upgrade --old-bindir="c:\Program Files\PostgreSQL\9.1\bin"
--new-bindir="c:\Pro
ration and the output redirection,
into the -o option's value. The output from pg_upgrade itself, as well
as the referenced log file (see below) have such an unintelligible
mess of quotation marks that I cannot tell whether it's correct there.
pg_upgrade_utility.log:
command: ""c:\Program Files\PostgreSQL\9.1\bin/pg_ctl" -w -D
"c:\Daten\db\pgsql" -o "" stop >> "pg_upgrade_utility.log" 2>&1"
command: ""c:\Program Files\PostgreSQL\9.1\bin/pg_ctl" -w -D
"c:\Daten\db\pgsql" -o "" -m fast stop >> "pg_upgrade_utility.log" 2>&1"
Is there anything I can do to avoid this? Should I report it as a bug?
--
Christian
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On Sat, Jun 30, 2012 at 4:32 PM, Jerry Sievers wrote:
> Christian Rosnes writes:
> > Doing a:
> >
>
> ? psql -U postgres -d postgres -c "select * from? pg_prepared_xacts;"
> >
> > I see that there are 72 transactions (across the 5 databases in this
>
On Sat, Jun 30, 2012 at 3:55 PM, Jerry Sievers wrote:
> Christian Rosnes writes:
>
> > Hi,
> >
> > Coming back from vacation, I find a PostgreSQL database cluster (Pg
> version: 9.0.4)
> > with 5 databases, which for the past 5 days have logged these messages:
&
rename the the datadb cluster dir: mv /dbcluster /dbcluster.old
do a new initdb /dbcluster
restore the 5 databases to new /dbcluster
Or are there anything else I could try to fix this ?
Thank you
Christian
* Craig Ringer wrote:
On 06/16/2012 08:36 PM, Christian Ullrich wrote:
The one-click installer (assuming you used that) left you with
PostgreSQL running under a local account named "postgres". First, you
have to change that, because SSPI requires that the service uses a
doma
. Which is a good thing, because it does not work
reliably on Windows anyway.
--
Christian
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
, client
address, and claimed user name is used.
--
Christian
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
nes, so you
can get in even if it does not work right.
7. Start the PostgreSQL service.
You can use the "klist" command on the clients to check whether they
get service tickets from the domain controller.
Good luck.
--
Christian Ullrich
--
Sent via pgsql-admin mailing l
msi/psqlodbc_09_01_0100-1.zip>.
Is there an ODBC for Windows-64 available and does it work with a
32-Bit application ?
With 32-bit applications, use the 32-bit driver.
--
Christian
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription
* Gnanakumar wrote:
We're using PostgreSQL v8.2.3.
How do I get the schema name in which TEMPORARY table is created using
"CREATE TEMP TABLE mytable " syntax?
SELECT nspname FROM pg_namespace WHERE oid = pg_my_temp_schema();
I don't have an 8.2.3 lying around, but git says that function
field_name in ('SOI','RelLoc','Description','Heading','news_date') and
field_value != '' ;
END;
' LANGUAGE 'plpgsql';
You are using single quotation marks around your function body already.
Use dollar quoting instead.
--
Chri
ation in the PATH of the
postgres service user? You wrote that you verified the command works,
but you didn't indicate if you had to specify the full path.
--
Christian
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
* Anuj Pankaj wrote:
Please help to run my postgres on remote manchine through pgAdmin III.
Do you have a firewall on the database server or anywhere between your
Windows client and the database server that might be blocking the
connections?
--
Christian
--
Sent via pgsql-admin mailing
king again.
What can I do to fix this? As far as I can tell, PostgreSQL already
ships with libraries from the latest Kerberos for Windows release (even
though KfW 3.2.2 is three years old by now).
Thanks in advance for any help.
--
Christian
--
Sent via pgsql-admin mailing list (p
nformation to find anywhere in the
package i bought, it simply saidthat the installation would pretty much install
itself, and no suchinformation was needed for the install.What will I have to
do in order to get this working?
Thank you!
Christian Larsen
[EMAIL PROTECTED]
_
tables
or something of that sort.
I would recommend comparing the output of vacuum full with and
without your application connected.
Greetings
Christian
--
Christian Kratzer [EMAIL PROTECTED]
CK Software GmbHhttp://www.cksoft.de/
Phone: +49 7452 889
r does not complain of files changing
underneath we prefer to avoid the additional complexity and of
filesystem snapshots and just plain tar the data directory
without the pg_xlog subdirectory.
Greetings
Christian
--
Christian Kratzer [EMAIL PROTECTED]
CK Sof
hi again,
2006/2/22, Tom Lane <[EMAIL PROTECTED]>:
"Christian Sengstock" <[EMAIL PROTECTED]> writes:
> The function is created outside of the 'geo' schema, but after that, the> 'alter function' statement tries to alter the function inside of the &#
hi list,
i have a auto-generated restore.sql script which doesn't work for me
because of an obvious error inside of it. because the script is working
for other people i thought of an os error (i use linux, others
windows).
the problem:
The function is created outside of the 'geo' schema, but af
2006/1/30, Uwe C. Schroeder <[EMAIL PROTECTED]>:
On Monday 23 January 2006 00:49, Krzysztof Szadkowski wrote:> Hi all,>> I am looking for a way to copy whole database to another existing
> database.> Any suggestions ?
Sometimes you want to copy the whole DBMS to another machine where the same po
en las que he pensado no me parecen adecuadas. Ayudenme por favor si han realizado algo parecido alguna vez o tienen alguna idea de cómo hacer esto...Gracias...Yessica Brinkmann Baruja.
-- Christian Sengstock - Tel: 06221 / 650 5889, Mob: 0178 / 38 79 671
?
D 07:58 0:00 postgres: postgres wlan [local]
DROP TABLE
i cannot kill it with kill -9, and also i'm not sure if i should. maybe the database is not running after it at all?
anyone got any hints?
thanx,
chris
-- Christian Sengstock - Tel: 06221 / 650 5889, Mob: 0178 / 38 79 671
Please Unsuscribe me.
Thanks.
---(end of broadcast)---
TIP 6: explain analyze is your friend
column's datatypes do not match
[ \ /
[ >X< Christian Fowler | spider AT viovio.com
[ / \ http://www.viovio.com | http://www.tikipro.org
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an
f course dbtuning is running on postgres ;-)
[ \ /
[ >X< Christian Fowler | spider AT viovio.com
[ / \ http://www.viovio.com | http://www.tikipro.org
---(end of broadcast)---
TIP 8: explain analyze is your friend
forge )
Execution stalls on reaching pg_connect() .
can you give some pointers to this. I have tried all docs that I could :(
-Sukhdeep
[ \ /
[ >X< Christian Fowler | spider AT viovio.com
[ / \ http://www.viovio.com | http://www.tikipro.org
---(end o
after the live
servers.
[ \ /
[ >X< Christian Fowler | spider AT viovio.com
[ / \ http://www.viovio.com | http://www.tikipro.org
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
7;@'
The explicit join syntax was freaky for me too at first, but after
several years, I prefer it now, since you can easily control your left
outer joins
[ \ /
[ >X< Christian Fowler | spider AT viovio.com
[ / \ http://www.viovio.com | http://www.tikipro.org
---(end of broadcast)---
TIP 8: explain analyze is your friend
ED] so that your
message can get through to the mailing list cleanly
[ \ /
[ >X< Christian Fowler | spider AT viovio.com
[ / \ http://www.viovio.com | http://www.tikipro.org
---(end of broadcast)---
TIP 2: you can get off all
lines) and UNICODE to UTF-8.
--
Markus Bertheau <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 8: explain analyze is your friend
[ \ /
[ >X< Christian Fowler | spider AT viovio.com
[ / \ http://www.vi
db-# ;
server_encoding
-
SQL_ASCII
(1 row)
whoa! yikes, I bet this has a lot to do with it? I really wanted to keep
everything UNICODE end-to-end. I must have forgotten --encoding on my
initdb? Anything I can do at this point?
On Mon, 15 Nov 2004, Tom Lane wrote:
Christian
[shell]$ env
PGCLIENTENCODING=UNICODE
LANG=en_US.UTF-8
db=# \encoding
UNICODE
On Mon, 15 Nov 2004, Tom Lane wrote:
Christian Fowler <[EMAIL PROTECTED]> writes:
After much wrestling, it appears the hex byte sequence #bfef in a VARCHAR
column causes a truncated COPY line to be written (and th
ort each copy row in it's own
transaction so 5+ million copied rows don't fail for 6 bogus ones. Perhaps a
--this_is_an_emergency_so_please_do_everything_you_can_to_restore_as_much_as_possible
option.
If any of the core dev's want some small debug dumps I created, I'd be
happy t
p fiddling and it should hopefully start up.
On Fri, 29 Oct 2004, Ivan Dimitrov wrote:
Hi list
This is my first post here, and I've searched google but couldn't find the
solution.
I'm trying to run pg_autovacuum on all my databases. All my Debian sarge
machines use version 7.4.5-
acter varying(200) |
mod_date | timestamp without time zone |
pc_char | character varying(4)|
dim_char | character varying(16) |
[EMAIL PROTECTED] root]# env |grep LANG
LANG=en_US.UTF-8
On Wed, 20 Oct 2004, Weiping wrote:
Christian Fowler wrote:
I'm running a larg
even waste time installing the NIC's I would like a sense of how
hard it is to get postgres to use that kind of a connection vs over the
Internet. We are looking to increase communication speed between the web
servers and database server as much as possible.
Thanks
Kent Anderson
[ \ /
[ &g
here is a short
row (by two), and two fields in on the *next* line is indeed a "4"
Both seem to have the same problem - incomplete COPY row data. any ideas?
[ \ /
[ >X< Christian Fowler | [EMAIL PROTECTED]
[ / \ http://www.viovio.com | http://www.tikipro.org
Thanks Tom, it appears that was the issue. Bruce, it would appear it
was at some point? Glad to hear it's now insensitive.
On Sun, 17 Oct 2004, Bruce Momjian wrote:
FYI, it is not case-sensitive in current CVS.
Tom Lane wrote:
Christian Fowler <[EMAIL PROTECTED]> writes:
I have \set
main=# rollback;
ROLLBACK
host.domain=# begin;
BEGIN
host.domain=# update foo set foo_type_id = 3 where foo_id=20234;
UPDATE 1
host.domain=# rollback;
ROLLBACK
host.domain=# \q
[ \ /
[ >X< Christian Fowler | [EMAIL PROTECTED]
[ / \ http://www.viovio.com | http://www.tikipro.org
---
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
[ \ /
[ >X< Christian Fowler | [EMAIL PROTECTED]
[ / \ http://www.viovio.com | http://www.tikipro.org
---(end of broadcast)
Igor,
I would recommend you investigate LVM:
http://www.tldp.org/HOWTO/LVM-HOWTO/
This enables you to string multiple physical units into a single volume -
as well as expand and grow the volume. I am unsure about postgres
consequences of this for as much data as you have, so I will leave it up
I would like to also add that I've been a sysadmin for quite some time, and
I've been designing databases for quite some time as well. I'm no idiot, I
just can't find the bottleneck here (if one does in fact exist). So in light
of this, please send me some suggestions I can work with.
Here are thr
Hi Shane,
As many others have alluded to - performance like this is almost always
attributable to your queries not using an index. Be it on Oracle, Mysql,
or postgres, i have seen this problem popup often.
Also, could you tell us what language you are using, and if you are using
a DB abstractio
Christian
Hola a todos,
Tengo una inquietud sobre el porstgres, soy nuevo
en esto y no se como hacerlo.
Tengo una base de datos maestra en PostgreSQL
V7.4.3 sobre Linux Red Hat 9, de la cual a cada usuario le genero un dump con la
estructura y alguna data de la misma y se las importo en sus notebook
and try it again.
All the data are stored in the public schema.
Thanks a lot for helping me!
Christian
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFBEc66BaT26XNCfvQRAn2uAJ4gN+tFuNaxllRmEKls3Bm0/jg8qQCfasTg
como usarlo
ya sea por consola o entorno grafico (si es que es posible), ni tampoco
como usar la ayuda, alguien me podria dar una mano de como empezar a utilizar
esta herramienta, para poder migrar mis bases access.
Gracias
Christian
Muchas Gracias
Christian.
otra forma
de hacerlo, alguien me podria dar una mano?
¿Alguna otra idea para convertir el mdb a
postgresql?
Un saludo,
Christian
ata local to the database
session.
As far as I know there are no session local variables in postgresql.
I could use something like this myself. The only workaround I know of
to have data local to a session is to create a temporary table for the data.
There are local variables in plpgsql if you are ju
I'm attempting to invoke the postmaster through the cygwin unix emulater on windows
and I keep getting the following error in the log:
FATAL: /bin/postmaster: could not locate postgres executable
I've checked and the postgres executable is where is should be in /bin. Does anybody
have any sug
I look for theese backports, someone could help?
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
I am running 7.3.2.
I will update to 7.3.4 as soon as possible.
If the problem is still there after the update, I will post once more
the issue.
Thank you for your help
Best Regards
Christian Brosig
Gaetano Mendola <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> "Chris
Hi all,
during a sql statement (running in pgadmin III) I got an error message:
Out of buffer error - Time to abort
Which buffers are meant?
How could I increase the amount of these buffers?
I hope someone could help me ...
Regards,
Christian
---(end of broadcast
: Relation “pg_relcheck” does not
exist
What is the reason? What must I do?
I hope anyone could help me.
(Please reply also directly to [EMAIL PROTECTED])
Thanks.
Christian Brosig
> > ~~
> > Error: DBD::Pg::st execute failed: ERROR: deadlock detected at
> > /usr/local/perlapache/lib/perl/Banner.pm line 71, line 7.
> > ~~
>
> It is a genuine error, occurs while two or more transaction process tries
> to update/delete a same record sim
I am looking for any discussions on when to use BLOB's as opposed to storing
files on a filesystem. If someone knows of a published discussion or has
some pearls of wisdom on this I would greatly appreciate it.
Christian Brink
[EMAIL PROTECTED]
---(end of broa
In my work with he Progress RDBMS, I had a delta tool to take the schema
changes between an old db and a newer version and make a sql (delta) file to
update the older version.
Is there such a beast for postgresql??
Thanks,
Christian
---(end of broadcast
We installed Postgres on a Redhat system using rpm.
The default directory is /var/...
We would to change to /usr/mybases without destroying existing bases.
How to do?
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.408 / Virus Da
Hi, I'm new to PostgreSQL. I just download the source and want to begin
compiling it. However I am not sure what options to give ./configure.
All of the data for the database will be in Japanese or ASCII.
I want to configure the data so that it can store japanese without
mangling and can also
iatly 300.000 times. This means for me:
there is no chance to store my db directly on flashdrive.
If i could let my databases stay in RAM (maybe RAM-Drive, if so) i may do a backup to
flashdrive in a defined frequency!?
Some thoughts? Please give me some hints...
tia
Chri
like what you are
doing. You clients may not like it, but they'll hate a really buggy system
more.
Christian Brink
CTO
ONSITE! Technology
www.onsitetech.com
503.233.1418
[EMAIL PROTECTED]
Taking e-Business and Internet Technology To The Extreme!
> -Original Message-
> F
> 4) I cant connect using ODBC in ER/WIN any more.
> I get : password crypt authetification not supported.
>
> 5) I cant connect using ODBC in pgAdmin any more.
> I get : Incorrect password
Think I found it : ODBC doesn't seems to support crypt.
---(end of broa
Hello,
I'm a college student in a db development course. I use postgres 7.03 on
RedHat 7.1, I need help setting foreign key constraints and I cannot find in
the doc's and I cannot access postgres.org. I have a db due literally
yesterday, if I can't get it in tomorrow I lose my hard earned 'A'.
HE
That helped, thanks!
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]] On Behalf Of Stefan Huber
> Sent: Friday, April 27, 2001 6:32 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [ADMIN] ODBC connection to PostgreSQL
>
>
>
> >Now I wonder how I have to configure
I installed the PostgreSQL ODBC dll, but everytime I'm trying to connect
to my database server (witch is another machine in my network) I get the
error "Couldn't connect to server, couldn't connect to remote socket"
Now I wonder how I have to configure the postmaster to get this
working...
Teln
Is PostgreSQL journalized? Can it be made to do so?
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
ECTED]]On Behalf Of Stefan Huber
> Sent: Monday, March 12, 2001 10:53 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [ADMIN] Compiling error... plz hlp
>
>
> Servus Christian!
>
> At 22:07 2001-03-12 +0100, Christian Marschalek wrote:
> >I get the followig error although TK is i
I get the followig error although TK is installed
-start
make[2]: Nothing to be done for `all'.
make[2]: Leaving directory `/mnt/hdb/src/postgresql-7.0.3/src/bin/pgaccess'
make[2]: Entering directory `/mnt/hdb/src/postgresql-7.0.3/src/bin/pgtclsh'
gcc -I../../include -I../../backe
I get the followig error although TK is installed
-start
make[2]: Nothing to be done for `all'.
make[2]: Leaving directory `/mnt/hdb/src/postgresql-7.0.3/src/bin/pgaccess'
make[2]: Entering directory `/mnt/hdb/src/postgresql-7.0.3/src/bin/pgtclsh'
gcc -I../../include -I../../backe
Found a solution,
Copied file libpq.so.2.1 to /var/lib
C. Anton
"Christian Anton" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Good day all,
>
> I'm a newbie running latest distro on Linux (RH 7.0, 2.2). I used the R
antly, what the heck does this file do?
Christian Anton
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hi,
I have read that PostgreSQL has a row size limitaton to 8 or 32 Kb. Is this
true? Doesn't exist any way of surpassing this limitation?
Isn't that a serious limitation for a datababase?
documentation to raise whatever parameter is necessary to avoid this
problem?
Thanks a lot,
Christian Pomar
Please, note that my reply mail has the #NOSPAM# token to avoid spam; just
remove it before sending email.
Thanks again
>
> Will the postgres community ever consider creating a decent backup
> capability. Currently the way to create backups is through a Cron job.
> For Postgres to ever be considered a true production systen then some
> sort of transactional tracing has to be done. Otherwise you risk the
> potentia
Dear list,
a few weeks ago I installed postgres V. 7.0.2 on my IBM RS/6000. Since I used a
precompiled package for AIX 4.3.3 downloaded from the AIX freeware Library at
"http://ftp.univie.ac.at/aix/", I am now missing two libs necessary to use perl
and tcl/tk with "createlang".
aside:
To b
set digest
Ce message contient des informations confidentielles ou appartenant au
Crédit Lyonnais et est établi à l'intention exclusive de ses
destinataires. Toute divulgation, utilisation, diffusion ou reproduction
(totale ou partielle) de ce message, ou des informations qu'il contient,
doit
> From [EMAIL PROTECTED] Tue Nov 7 09:30:35 2000
>
>
> Hi,
> i'm searching for documentation about instruments that postgresql offers about
>distribution of databases on different machines and
> comunications beetwen the dbs.
>
> Thank you.
>
> Enrico Mangano
>
Dear list, and author,
plea
Mon, 6 Nov 2000 12:11:20 +0100, SILVAN wrote:
>
> I've just upgraded Redhat RPMs from Postgres 6.5.3 to 7.0.2 on two servers
> and run into the same problem on both. When I call the client psql:
>
> psql database_name -U postgres
>
> I'm not asked for a password and every user can access the
set digest
Ce message contient des informations confidentielles ou appartenant au
Crédit Lyonnais et est établi à l'intention exclusive de ses
destinataires. Toute divulgation, utilisation, diffusion ou reproduction
(totale ou partielle) de ce message, ou des informations qu'il contient,
doit
subscribe pgsql-admin
subscribe
set digest
ks in advance
begin:vcard
n:Rossi;Christian
x-mozilla-html:FALSE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:System Administrator - http://www.ariadne.it">Ariadne.
org;quoted-printable:http://www.cib.unibo.it - CIB Centro Inter-Bibliotecario;Università=3B di Bologna - Bolog
Hi everybody!
Just a simple(?) question. What do i need to do for backing up a Postgres
database? Do I have to close the database before running the backup or what?
I guess this DB is also not backup up when running - am I right?
Thanks in advance
Christian Atteneder
set digest
Ce message contient des informations confidentielles ou appartenant au
Crédit Lyonnais et est établi à l'intention exclusive de ses
destinataires. Toute divulgation, utilisation, diffusion ou reproduction
(totale ou partielle) de ce message, ou des informations qu'il contient,
doit
On Tue, 25 May 1999, Jim Burnett wrote:
> In access when I try to link a table I get an authentication failed. I
> tried to add a user using createuser, but i didnt pompt me for a
> password. Also, do i need to add users to each database i make or just
> using the createuser in ./bin ? i tried to
> I' like to know if you can suggest me how I can import data in a postgresql
> table from a .txt file (with fields separated by semicolon )
Using psql, you can issue a
COPY tablename FROM '/dir/textfile' USING DELIMITERS ';';
Which should work fine.
tablename should exist already and the fie
95 matches
Mail list logo
