Re: [ADMIN] Cast text to bytea

2003-12-02 Thread Godshall Michael
Title: RE: [ADMIN] Cast text to bytea Have you seen this? http://www.postgresql.org/docs/current/static/datatype-binary.html Maybe you need some backslashes? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Alvar Freude Sent: Tuesday, December 02, 2

Re: [ADMIN] row sorting in pgadmin3?

2003-12-05 Thread Godshall Michael
Title: RE: [ADMIN] row sorting in pgadmin3? Hi, I don't believe this an option in pgadmin3 at the moment.  You will have to add an "order by" to your sql statement. Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Info Desk Sent: Thursday, De

Re: [ADMIN] character type modification

2003-12-16 Thread Godshall Michael
Existing table column data types cannot be altered in any stable version of postgres(7.4 or previous).  I don't know if it is available in a beta release. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jodi KanterSent: Tuesday, December 16,

Re: [ADMIN] Dumping from version 7.3.4 to 7.4.1

2004-02-12 Thread Godshall Michael
I would guess that you need to do the pg_dump on the old machine, tranfser the file to the destination machine, open a psql window on the destination machine and then run the command to restore the database on that destination machine.   The command listed below might work if you were going