Re: [MonetDB-users] sql: getting (or specifying) sequence name

1 Jul 2010


      On Thu, Jul 1, 2010 at 8:31 AM, Mark Bucciarelli  wrote:
...
Never mind, sqlmanual.pdf to the rescue.
SELECT
  default
FROM
  columns
WHERE
  table_id = %d AND
  name = 'id'
;
For the archives; you must quote the symbol
default in the above query for it to work.

sql>select "default" from sys.columns where table_id = 4186 and name = 'id';
+-------------------------------------+
| default                             |
+=====================================+
| next value for "django1"."seq_4176" |
+-------------------------------------+
1 tuple
sql>

m