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