I am using PGSQL 8.2.3. I took a backup of my database selecting "Plain"
option from pgAdmin 1.6. When I am trying to restore it to a new machine
having PGSQL 8.2.3 installed, using pgAdmin, the OK button of the "Restore
Backup Window" remains disabled. Why?
I am using PGSQL 8.2.3 on Windows XP and pgAdmin 1.6.3. While adding columns
to a table from pgAdmin front-end, an option appears "sequence" with a
drop-down box on the column creation window, but it remains disabled. I have
already created a sequence but want to connect that sequence with this
co
You must set the type of column to be serial or bigserial.
Regards.
Quan
On Mon, 2 Apr 2007 10:50:26 +0530
"Rohit Khare" <[EMAIL PROTECTED]> wrote:
> I am using PGSQL 8.2.3 on Windows XP and pgAdmin 1.6.3. While adding columns
> to a table from pgAdmin front-end, an option appears "sequence" wi
Hi.
Please see,
http://www.pgadmin.org/docs/1.6/backup.html
pg_dump does not support all options for all backup file formats. Particularly, to backup
blobs the PLAIN format can not be used. Also, a PLAIN file can not be interpreted, and
can not be restored using pgAdmin. The PLAIN format will