Hi all,
First a bit of background, I am using RH6.1 on intel and my
window manager is HelixGnome with Sawfish.
Now, I sure hope someone can help me, I started with a
functioning pgsql 6.5.2-1 and decided to upgrade it with
the current version 7.0.2-2. I saw on the Download page the
comment about
I am trying to get data from a table in postgres database through a RemoteObject.But I
am getting
Exception:
java.io.NotSerializableException: postgresql.jdbc2.Connection
Does postgres support serialization.
Can you help me out.
Chequemail.com - a free web based e-mail service that also pay
try ...mydatab=>\dt
good luck!
Glenn...
<[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> How can I retrieve the "names" of all the tables in my database ?
>
> TIA
> On Wed, 16 Aug 2000, Daniel Sjölie wrote:
>
> > What bothers me is how
> > hard it is to update functions (primarily triggers) in a nice way.
> >
> > Using a procedural language is a lot easier but I find it a real pain to
> > edit functioins created in this way since they're only stored in th
> How can I retrieve the "names" of all the tables in my database ?
In Postgres 7:
>From psql: \dt
or \d for all objects
>From SQL:
select * from pg_tables where tablename not like 'pg_%';
Hello,
In this table one can see that OID 178502 was created after OID 178593.
Is this normal behaviour? I thought that OID sequences kept going up.
oid | login | price |created
+---+---+
178383 | vindex| 32500 | 2000-08-
On Thu, Aug 17, 2000 at 05:00:49PM +0800, Paul Juliano wrote:
> installing PL/pgSQL .. createlang: missing required argument PGLIB
> directory
I don't know about this one.
> Also, when I do:
>
> make runcheck
>
> the following message is in the postmaster.log
>
> IpcSemaphoreCreate: semget
Hi,
I've installed PostgreSQL 7.0.2 on Solaris following the INSTALL file
that comes with the source.
When I do:
make runtest
it gives out the following error message in regress.out:
postmaster must already be running for the regression tests to succeed.
The time zone is set to PST8PDT for th
in C, I work on a database (4 table).
COPY FROM file ;
SELECT, INSERT, UPDATE, DELETE for a result in the last
table.
COPY TO file ;
in the file, are stored 1 informations.
-> It's slowly !!!
Can you help me for optimization this?
I
Hi,
> How can I retrieve the "names" of all the tables in my database ?
Not sure what you are using but if you use DBI perl interface you can
use
this two functions :
$sth = $dbh->table_info;
@names = $dbh->tables;
They works well with DBD::Pg.
In psql simply type \d. this is certainly n
10 matches
Mail list logo
