Re: [ADMIN] FW: Restore pg_dumpall

2010-05-29 Thread Kevin Grittner
ALEXANDER JOSE wrote: Perform a backup with the following command; pg_dumpall-Upostgres and record it in a file called respaldo.sql postgres in my instance I have 22 databases, I wondered if the above command I have supported all my databases and I use another command. http://www.postgresq

Re: [ADMIN] Oracle's Long data type equivalent data type in Postgresql ?

2010-05-29 Thread Igor Neyman
> -Original Message- > From: Achilleas Mantzios [mailto:ach...@matrix.gatewaynet.com] > Sent: Friday, May 28, 2010 5:03 AM > To: pgsql-admin@postgresql.org > Subject: Re: Oracle's Long data type equivalent data type in > Postgresql ? > > Στις Friday 28 May 2010 11:45:17 ο/η Ravi Katka

[ADMIN] What is field separator?

2010-05-29 Thread Tena Sakai
Hi Everybody, I am a bit confused about field separator. In psql, \pset command lets me change this value from the default to something else. I thought field separator was “|” below: marker | allele | afreq | fam_ |p ++---+--+-- RS2312724 | 2 |