> Can someone show me how to create (and use) an int8
> sequence?
>From what I can tell (both from docs and doing a
describe on sequences in my database), a postgresql
sequence is an int4, not an int8, and thus you are
limited to a max of 2.1 billion values.
If you require an int8 sequence, you'
I'm not sure if this is related, and unfortunately I
don't have the specific error in front of me, but on
occasion when I restart postgresql, using
$ /etc/rc.d/init.d/postgresql restart
I'll see the shutdown message, then I'll see a shared
memory creation error, which I think looked similar to
t
hi.
I just discovered that doing an alter table ... alter
column (to rename a column) does not do a complete
rename throughout the database.
for example, say you have table a, with columns b and
c. b is your primary key.
now rename b to new_b. if you do a dump of the schema
after you rename,
\d name_of_table
>
> You might also want to try
>
> \?
>
> for a list of all psql commands
>
> Regards,
> Patrik Kudo
>
> ech`echo xiun|tr nu oc|sed 'sx\([sx]\)\([xoi]\)xo
> un\2\1 is xg'`ol
> Känns det oklart? Fråga på!
>
> On Fri, 15
how can I get the schema of a table in psql?
in oracle I would do "desc tablename". I remember sql
server and ingres having a similar facility.
right now the only way I seem to be able to get the
information is by using pgaccess.
I realize the definition of the table is probably
spread across
I see in the TODO that left and outer joins are
supposedly a priority.
I do wonder what the status is, since the email
correspondence shows the most recent email as being
from something like march or july of 1999.
what is the status on left and outer joins?
thanks
michael
_
