* Bruce Momjian (br...@momjian.us) wrote:
> Scott Marlowe wrote:
> > Note that psql automagically right justifies numerics and dynamically
> > sizes all columns so you don't have to do as much of this stuff.
> > Oracle always made me feel like I was operating the machine behind the
> > curtain in t
* Bruce Momjian (br...@momjian.us) wrote:
> Joshua Gooding wrote:
> > Hello,
> >
> > I'm looking for the postgres equivalent of oracles: set numwidth
> > command. Is there an equivalent?
>
> If we knew what it did, we might be able to help you.
Changes the display-width for numeric values. SQ
* Joshua Gooding (jgood...@ttitech.net) wrote:
> I'm looking for the postgres equivalent of oracles: set numwidth
> command. Is there an equivalent?
Nothing really equivalent, I don't believe.. You would need to wrap
the column(s) you care about using to_char().
Thanks,
Andrew,
* Andrew Hall (andre...@hotmail.com) wrote:
> 2. Non-default role -> a role which has to be explicitly activated during the
> lifecycle of an application in order to gain access to database resources.
> There are no limits on the number of non-default roles. This type of role
> helps us
* Glenn Maynard (gl...@zewt.org) wrote:
> > The ORM can't control transactions, can't call functions or can't set
> > savepoints?
>
> It can't write the necessary SQL to say "insert this unless it already
> exists", namely:
If it can't cleanly handle failure cases like this one, then I think
your
* Alan Chandler ([EMAIL PROTECTED]) wrote:
> I am rather new to Postgres (running 7.4) but I am trying to port some PHP
> code that has been built to run with mysql.
>
> I have got stuck trying to find the equivalent of the Mysql "DESCRIBE
> ;" SQL statement that lists the columns and type ident
* Jeff Kowalczyk ([EMAIL PROTECTED]) wrote:
> Is there a postgresql SQL idiom to perform an UPDATE, which becomes an
> INSERT if the primary key does not exist?
>
> I'm not sure I *should* use it in my application, I just want to know if
> it can be done. Thanks.
Unfortunately, I don't believe th