Re: [SQL] get table schema in psql?

2000-09-15 Thread Roderick A. Anderson 

On Fri, 15 Sep 2000, Rommel B. Abaya wrote:

> type \d [tablename] at the psql console

And if you like that try:

\d+ [tablename]

Of course it's much more impressive if you've created any COMMENTs.


Rod
--
Roderick A. Anderson
[EMAIL PROTECTED]   Altoplanos Information Systems, Inc.
Voice: 208.765.6149212 S. 11th Street, Suite 5
FAX: 208.664.5299  Coeur d'Alene, ID 83814

Re: [SQL] Alternate Database Locations

2000-10-25 Thread Roderick A. Anderson 

On Tue, 24 Oct 2000, Brian C. Doyle wrote:

> Never mind... I got it working

OK, don't play your cards so close to the vest.  What was the problem (and
solution)?


TIA,
Rod
--
Roderick A. Anderson
[EMAIL PROTECTED]   Altoplanos Information Systems, Inc.
Voice: 208.765.6149212 S. 11th Street, Suite 5
FAX: 208.664.5299  Coeur d'Alene, ID 83814

Re: [SQL] password encryption

2000-07-21 Thread Roderick A. Anderson 

On Fri, 21 Jul 2000, Silesky Marketing Inc, Support wrote:

> Hello,
> 
> I want to encrypt passwords with Postgresql the way mySQL does it with :
> 
> UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';

Check out the ALTER command.

ALTER USER username
[ WITH PASSWORD 'password' ]
[ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]
    [ VALID UNTIL 'abstime' ]


Rod
--
Roderick A. Anderson
[EMAIL PROTECTED]   Altoplanos Information Systems, Inc.
Voice: 208.765.6149212 S. 11th Street, Suite 5
FAX: 208.664.5299  Coeur d'Alene, ID 83814