agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: perera@pollux.cs.uga.edu
To: postgres@postgres.Berkeley.EDU
Subject: attribute question
Date: Thu, 28 Apr 94 22:56:07 EDT
Message-ID: <9404290256.AA06776@pollux.cs.uga.edu> (raw)

Hi:

How does one get all attributes except one from a table ?

I tried the following...

retrieve into temp ( s.all )
where pg_class.relname = "s" and  pg_attribute.attname !~ "sno" \g

which did not work...

-- Niranjan


===============================================================================
    To add/remove yourself from the POSTGRES mailing list: send mail with 
    the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

    If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
    a human will deal with it.  DO NOT post to the "postgres" mailing list.
===============================================================================

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: perera@pollux.cs.uga.edu
  Subject: Re: attribute question
  In-Reply-To: <9404290256.AA06776@pollux.cs.uga.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox