Easiest way is with pg_dump -s -t tablename dbname
On Sat, Jul 4, 2009 at 6:35 AM, Jasmin
Dizdarevic wrote:
> Nice Information. Does somebody know how to get the complete
> create-statement of an existing table/view?
>
> 2009/7/3 Chris Browne
>>
>> Andre Rothe writes:
>> > Where are stored the s
Nice Information. Does somebody know how to get the complete
create-statement of an existing table/view?
2009/7/3 Chris Browne
> Andre Rothe writes:
> > Where are stored the sequence information? How I can query the
> > properties of a sequence like increment, max/min value, cache?
> > I'm look
Andre Rothe writes:
> Where are stored the sequence information? How I can query the
> properties of a sequence like increment, max/min value, cache?
> I'm looking for a table like user_sequences in Oracle, where I
> can query all of my sequences.
cbbrowne=# create sequence foo;
CREATE SEQUENCE
c
