Skip site navigation (1) Skip section navigation (2)

pg_dump question

From: linhluong(at)canada(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump question
Date: 2004-05-31 16:30:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
Hi everyone,

I need some help
Can I dump specifc table and still get the actual sequence for it.
Somehow when I go 

pg_dump -Fc -t <table name> -D <dbname> 
it only give me the for that table
create table text
all the indexes
all the triggers

However, it totally does not bring in the sequence for that table
create table address (
  id integer DEFAULT nextval('address_id_seq'::text) NOT NULL
  phone1 text
and address_id_seq is not mentioned anywhere in the dump file? 
Am I doing something wrong? 
Any insight would be appreciated.

How can I get it?
Thanks a bunch


Linh Luong


pgsql-general by date

Next:From: Philip A. ChapmanDate: 2004-05-31 19:14:38
Subject: Re: Poatgresql database on more than one disk
Previous:From: Cyril VELTERDate: 2004-05-31 16:02:22
Subject: Re: Dump 7.1.3->7.4.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group