Re: SELECT all fields except two

This does not exist in SQL. However you could achieve similar
functionality by doing a suitable query against the system info tables
to find out what columns are available and then building your query
appropriately.

For an example, try
psql -E -c '\d mytable'

Drew

Pit M. wrote:
> select *,!Blob1,!Blob2 from MyTable
>
> Perhaps this is a construction that doesn't exist in the current SQL
> standard at the moment.
> Does anybody know the solution for that problem without explicitly
> specifying the whole field list like:
>
> select Field1,Field2,...Field100 from MyTable
>
>
> HP