Try typing "\dt" from the psql prompt of the database whose table list u
want
On Thu, 17 Aug 2000 [EMAIL PROTECTED] wrote:
> How can I retrieve the "names" of all the tables in my database ?
>
> TIA
>
have any installation files that combine both postgreSQL and PHP
together without the need to configure one by one?
hello...
Has anyone try to have multiple databases...
How postgres works distributing the jobs
between more than one server???
Thanks..
Meibell
pd: Do you see the article about postgres in http://www.slashdot.org/
I've heard some rumours off Slashdot that PostgreSQL databases tend to
corrupt more than, say, MySQL, and that disaster recovery is more
difficult. So far I've not much database administration experience, so
I cannot say whether this is true or not. I rely on you for the
answer. Is this true or no
I've sent this once before but it didn't seem to get through
(couldn't find it in the archive)
Hi...
What is the recommended way to make changes to a database in use?
The database is not critical, I can take it down for a day or so but I'd
rather not (or as little as possible anyway). What bot
I just want to add that these benchmarks actually somewhat validate my own
testing.
I was evaluating PostgreSQL vs. MS SQL Server two months ago. I ran a
series of tests that I felt approximated the load that was then current. We
had a database that ran on MS SQL Server, and I was trying to conv
How can I retrieve the "names" of all the tables in my database ?
TIA
On Thu, 17 Aug 2000, John Morton wrote:
> That much works for me, thanks. I was looking at adding uniqueness across
> fields but I can do that with CREATE INDEX, so it's not a showstopper.
> If I was trying to add other contraints I'd be having more trouble. I seem
> to recall that the rename/cre
On Wed, 16 Aug 2000 10:28:24 -0500 you wrote:
> On Wed, Aug 16, 2000 at 06:44:27PM +1200, John Morton wrote:
> >
> > What happened when I tryed it:
> >
> > DBD::Pg::db do failed: ERROR: ALTER TABLE / ADD CONSTRAINT is not implemented
> >
> > If I find another unimplemented 'feature' of
Hi,
I have been having serious problems with upgrading from 6.5.3 to 7.0.2. I
currently have 6.5.3 running in what was the default locations for the RPMS
(I am running it on an Alpha box with Red Hat Linux 6.2). I wanted to keep
that going and configure 7.0.2 so that it is located in a diffe
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> IIRC you cannot use commands
> like CREATE TABLE (etc) from PL/PGSQL (You'll get a cannot copy
> node)
Actually, this is fixed in 7.1.
Ian
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.1 (GNU/Linux)
Comment: For info see http://www.gnupg.org
Actually, this isn't so inane... Let's say I have table A keeping track
of other tables, and those tables detail bandwidth usage. I want to do
a subselect like the flowing, but I'm not sure how. Take a look. Any
ideas? Thanks.
-g2
SELECT *,
SUM(octets)
Ross J. Reedstrom writes:
> On Wed, Aug 16, 2000 at 02:36:10PM +, [EMAIL PROTECTED] wrote:
> >
> > This is with regards to Postgres 6.5.
> >
> > While trying to ALTER RENAME a large table (203MB data file), an error
> > occured. \d displays the new table name, but there is no correspondin
Use the createdb program to create a database. For example,
./createdb testdb
Then, run psql specifying the testdb database. For example,
./psql testdb
Once you are successfully running psql, you can define new users
with the CREATE USER statement.. For example,
create user mauric
Craig,
Thank you very much for your help, this solved my problem, but now, when I
try to run "psql" I get the following:
[postgres@x ~/bin]$ ./psql
psql: FATAL 1: Database "postgres" does not exist in the system catalog.
What could be now?
J. Mauricio Cuenca H.
[EMAIL PROTECTED]
- Origina
On Wed, 16 Aug 2000, J. Mauricio Cuenca H. wrote:
> I installed PostgreSQL 7.0 on Linux RedHat 6.2, then I ran the initdb
> command without any problems or warnings. Then, when I try to run the psql
> interactive monitor, I get the following error:
>
> [postgres@x ~/bin]$ ./psql
> ./psql: error
16 matches
Mail list logo
