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


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to