Search code examples
sqlpostgresql-9.1sqldatatypes

How to declare DATALINK type? FOREIGN DATA WRAPPER in Postgresql


I'm trying to use DATALINK type for a field in my database. Could somebody write step by step how to do this?

I've declared:

CREATE TABLE casting_test
(
  id serial NOT NULL,
  url datalink
)
WITH (
  OIDS=FALSE
);

and got error that no such a datatype existst. SQL state: 42704.

What to do first?


Solution

  • PostgreSQL does not support DATALINK.