diff options
Diffstat (limited to 'sandbox/domainoid.py')
| -rw-r--r-- | sandbox/domainoid.py | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/sandbox/domainoid.py b/sandbox/domainoid.py new file mode 100644 index 0000000..0d98399 --- /dev/null +++ b/sandbox/domainoid.py @@ -0,0 +1,18 @@ +import psycopg2 + +con = psycopg2.connect("dbname=test") + +cur = con.cursor() +cur.execute("SELECT %s::regtype::oid", ('bytea', )) +print cur.fetchone()[0] +# 17 + +cur.execute("CREATE DOMAIN thing AS bytea") +cur.execute("SELECT %s::regtype::oid", ('thing', )) +print cur.fetchone()[0] +#62148 + +cur.execute("CREATE TABLE thingrel (thingcol thing)") +cur.execute("SELECT * FROM thingrel") +print cur.description +#(('thingcol', 17, None, -1, None, None, None),) |