Hi all,
I've somehow messed up something.
psql super
psql (8.4.5)
Type help for help.
super= \du+
List of roles
Role name | Attributes | Member of | Description
---+-+---+-
bobo | | {}|
junk |
Hey Steve,
2011/1/16 Steve Litt sl...@troubleshooters.com
Hi all,
I've somehow messed up something.
psql super
psql's synopsis is
psql [option...] [dbname [username]]
Thus, the call psql super connects psql to a database
super but since username unspecified it is connected
with
Thanks Dmitriy,
It turns out the solution I used was to su to postgres in Linux, and then run
the command psql without arguments, at which time I could have my way with any
object.
More in my responses to you...
On Sunday 16 January 2011 06:21:28 Dmitriy Igrishin wrote:
Hey Steve,
On 16/01/2011 20:56, Steve Litt wrote:
Thanks Dmitriy,
It turns out the solution I used was to su to postgres in Linux, and then run
the command psql without arguments, at which time I could have my way with any
object.
More in my responses to you...
On Sunday 16 January 2011 06:21:28 Dmitriy
On Sunday 16 January 2011 16:02:12 Raymond O'Donnell wrote:
If you have configured PG to listen on a TCP/IP port (5432 by default),
you can also do:
psql -U postgres -h localhost super
Ray.
Thanks Ray,
My psql seems a lot different from others. Loook what happened:
slitt@mydesk:~$
On 16/01/2011 21:39, Steve Litt wrote:
On Sunday 16 January 2011 16:02:12 Raymond O'Donnell wrote:
If you have configured PG to listen on a TCP/IP port (5432 by default),
you can also do:
psql -U postgres -h localhost super
Ray.
Thanks Ray,
My psql seems a lot different from others.
On Sunday 16 January 2011 16:02:12 Raymond O'Donnell wrote:
If you have configured PG to listen on a TCP/IP port (5432 by default),
you can also do:
psql -U postgres -h localhost super
Ray.
Thanks Ray,
You were so close! The command that works is this:
psql -U super -h localhost
On Sunday 16 January 2011 1:49:43 pm Steve Litt wrote:
On Sunday 16 January 2011 16:02:12 Raymond O'Donnell wrote:
If you have configured PG to listen on a TCP/IP port (5432 by default),
you can also do:
psql -U postgres -h localhost super
Ray.
Thanks Ray,
You were so
On Sunday 16 January 2011 1:49:43 pm Steve Litt wrote:
On Sunday 16 January 2011 16:02:12 Raymond O'Donnell wrote:
If you have configured PG to listen on a TCP/IP port (5432 by default),
you can also do:
psql -U postgres -h localhost super
Ray.
Thanks Ray,
You were so