A quick and dirty trick, is to make a dump of the schema
of the database (or the table):
postgres# pg_dump -s [-t employee] > db.dump.schema
Regards
Hernan Gonzalez
Buenos Aires, Argentina
> I've just started using Postgres 6.5.2 and I'm trying to figure out a
> way to be able to see the
> [EMAIL PROTECTED] writes:
> > I understand that the query planner cannot be so clever
> > to grasp that this particular function (max or min)
> > might be evaluated by just travelling the BTREE index.
> > Am I correct?
>
> You are correct --- the system has no idea that there is any
> c
> "Oakley " <[EMAIL PROTECTED]> writes:
> > When I did the configure, I did it with
> > --enable-syslog and with the --without-CXX
> > options. I read the online docs and created a
> > file in the /usr/local/pgsql/data directory
> > called postgresql.conf, and put in the options
> > I want
Well, I've tracked down the problem to its
mininal form, I think:
Here it goes:
[postgres@bert postgres]$ createdb test5
CREATE DATABASE
[postgres@bert postgres]$ psql test5
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with
Tom Lane wrote:
>> Timezone is set to America/Buenos Aires
>> Changing this seems to elliminate the bug.
> What did you change it *to*, exactly? And what dates did you test
> after changing?
I changed to "Etc/GMT+4" and tested the same just the same dates
>
Edward Q
>
> I'm wondering what would happen if I were to backup/archive an old
> database with OIDs, then later someday, restore it after I've since done an
> initdb and there is someother database using the same OIDs as the old
database.
> If I restore with OIDs, that would cause the OIDs to not be
