Re: [pgadmin-support] postgreSQL txt dump restore

2006-03-19 Thread Andreas Pflug

Andrew Madu wrote:

OS: Windows XP (Ver 5.1.2600) SP2
pgAmin III: Ver 1.2.2
posgreSQL: Ver 8.0
 
Hi,
I have a previously made postgresql full schema/data dumpo made to a txt 
file. How can I restore the database schema/data using pgAdmin,


As the FAQ states, you can't.

Regards,
Andreas

---(end of broadcast)---
TIP 6: explain analyze is your friend


Re: [pgadmin-support] Invalid password for \ and ' characters

2006-03-19 Thread Andreas Pflug

Andrus Moor wrote:

If password set by pgadmin contains \ or ' character, it is not possible to
login to pgAdmin

PROBLEM WITH \ character is password

To reproduce

1. Create new login role in pgadmin
2. Enter \ to password field.
3. Select SQL tab

Observed:

CREATE ROLE test LOGIN PASSWORD '\\'

Expected

CREATE ROLE test LOGIN PASSWORD '\'

Postres does NOT require backslashes in password strings.
PgAdmin probably uses its qtString for password strings.


AFAIR Dave recently changed that. Please check the CHANGELOG and try a 
newer version.


Regards,
Andreas

---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org


[pgadmin-support] Help

2006-03-19 Thread Henry Andres Sanabria Fuentes
I dont' speak english good.     How setting Slony I on Win32.  I have pgadmin 1.4
		LLama Gratis a cualquier PC del Mundo.Llamadas a fijos y móviles desde 1 céntimo por minuto.http://es.voice.yahoo.com